How to get last updated date

[Vikky]

Hi Experts;

I have different tables of data, which gets updated on daily basis. I
need to keep a record of tablewise data status. with updated date.

As Example:-
==========

Table Name data processed varified ,.... updated date

ab1 15445 1549 145 06-Oct'06
ab2 10545 5807 2456 06-Oct'06
ab2 10545 254 94 09-Oct'06
ab3 8545 5897 3456 09-Oct'06


Now i want to see a consolidated table status with last updated date.
So problem is which formula should i use to get tablewise last updated
date.

Please help me out.


Thanks & Regards,
Vikky

 

[Bob Phillips]

=LOOKUP(2,1/(E2:E100<>""),E2:E100)

adjust the range to suit

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)