cell reference

[Durai]

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.

 

[Gord Dibben]

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

 

[Durai]

Sorry I am not an expert My example is as follows>

Raw1 Monday Tuesday Wednesday Last
inventory
raw 2 2000 3000
3000

As above I like to have 3000 as last inventory as that was the last cell
updated lately. Please help.
Thanks

 

[Durai]

Works very well. Thanks. Please iqnore my earlier reply. Ihad to specify the
range and it worked.