Excel 2007 : Showing an the latest updated cell

Hello All

Need some help regarding my spreadsheet which im creating.

I have several columns of which a few contain the ability to put dates via a drop down list. This date tells the user when a certain section was done. Now I would like the ability to show this date in another cell which is located at the beginning of the spreadsheet (so the user can see at a glance when the spreadsheet was last updated) rather than having to scroll along trying to find the latest date. Im having trouble as the cell which shows the date can take any of the value from any of the columns but i need it to show the latest inputed date only.

Im really not sure where to start.

hope the above makes sense.

thanks in advance

Rich

The MAX function can show the latest date... see if MAX() is right for you.. EXCEL help files explains the function...

So in that cell that is "located at the beginning of another spreadsheet" validated too?

You need to put the MAX function in a separate cell that gives you the result you want.

Maybe you need to post a workbook example showing your intent.

Depends on the exact setup, but you can possibly use a Vlookup to look up the max date and enter the name that is in a column to the right of the dates... or Index/Match if the date is to the right of the name...

something like:

=Vlookup(X1,'Sheet2'!A1:B100,2,FALSE)

Where X1 is the MAX() date in the cell you entered my initial suggested function in... and Sheet2!A1:A100 contains the dates, B1:B100 contain the names...

or

=Index(A1:A100,Match(X1,B1:B100,0))

where X1 is as above, and A1:A100 contain the names, and B1:B100 contain the dates..

You can custom format the cell as...

mm/dd/yy;;