Microsoft Excel Formula Tutorial
Tuesday, October 6th, 2009
Recently take over a job to give assignment to a group of people weekly. Instead of manual, I decided to automate it using Excel. Of course la, I’m IT guy and you know IT guy always lazy ma. 
Frankly, I seldom use Excel and forgot how to use those formulas. Anyway, it is not too hard at all after some search on Internet.
Excel Lookup Formula
Basically I just need 2 function in Excel datasheet. First, able to tell the their latest assignment date in a row of date start and completion. Second, tell me which is their latest assignment.
I know it is easy for a programmer but I’m not. It took me some time to understand the tutorials. The two functions are as below: (more…)