cell reference

  • Thread starter Thread starter Durai
  • Start date Start date
D

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.
 
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
 
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
 
Works very well. Thanks. Please iqnore my earlier reply. Ihad to specify the
range and it worked.
 
Back
Top