Microsoft Excel Formula Tutorial
Posted in Tips & Tricks | By AhTim @ 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:
To retrieve the latest assignment date in a row. Make sure the column format to Date type, not General or text.
=MAX(column1:column2)
To check their latest assignment:
=lookup(value,row,result row)
I refer the value to the MAX formula column, then lookup the assignment as result row. It’s so simple with few line can ease my weekly job.
Do you use Excel formula too? Share with me your Excel formula and its usage. 
Random Articles
Tags: excel datasheet, excel formula, excel tutorial, vlookup
October 7th, 2009 at 7:35 pm
writing macro code for excel is too difficult.. i tryed once with a formula for comparing two columns and will produce the output in the third column if the columns are similar.. even for 2000 columns it hangs my system…