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 - 10 Oct 2006 18:22 GMT
=LOOKUP(2,1/(E2:E100<>""),E2:E100)
adjust the range to suit

Signature
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
> Hi Experts;
>
[quoted text clipped - 19 lines]
> Thanks & Regards,
> Vikky