Peo,

Thanks just what I wanted.

Thank U.

"Peo Sjoblom" wrote:

If the cells are always filled up to the last cell meaning if the first
filled cell is in C2 and the last cell in C30 all the cells in-between are
filled you can simply use

=INDEX(C2:C10000,COUNT(C2:C10000))

change the ranges accordingly if you think you will fill more than 10000
cells

post back if it's not that way

Regards,

Peo Sjoblom

"Pank" wrote in message
...
I have numerous sheets within a book where all cells in column C in all
sheets have the following formula "=IF(ISBLANK(P4),"",(R3-P4))". For you
reference both columns P and R hold a monetary value and are formatted as
Currency.

Is there a way that cell D1 can automatically be populated with the
contents
of the last cell in column C that has a value in it.

E.G.

Sheet 1, cell C19 has a value of 200, therefore cell D1 should be 200.
Sheet 2, cell C25 has a value of 250, therefore cell D1 should be 250.
Sheet 3, cell C99 has a value of 900, therefore cell D1 should be 900.

Any help offered would be appreciated.