Ron,

Thar worked a treat as well.

I understand the lookup, however, I do not understand the Can you please
explain what the 10^99, can you please explain.

If possible, can you also explain Peo solution.

Thank you for your time.

"Ron Coderre" wrote:

If you want the value of the last numeric value in the column range....

Try something like this:
D1: =LOOKUP(10^99,C1:C20)

Adjust the range reference to suit your situation.


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Pank" wrote:

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.