To return the number........

=LOOKUP(99^99,1:1)

To return the cell address.......

=ADDRESS(MATCH(99^99,1:1),1)


Gord Dibben MS Excel MVP

On Tue, 9 Jun 2009 09:16:01 -0700, Durai
wrote:

how can I reference to the last cell with numbers in a raw.
example column a to e in raw 2 are days. Column g is last cell updated amount.
When Monday is updated Monday amount and when Friday is updated Friday amount
Thanks.