Conker10382:

I'm not clear about your doubt. Do you mean that the 500 value is the
maximum in the range c1:c4?

Or, maybe the 500 value is on the first row of the range?

Please, could you please be more explicit?


--
Gaspar
PM --Adopting methodology--


"Conker10382" wrote:

I want to create a formula in a cell that will make that cell display the
value of the last cell in a column with a value greater than 0.
i.e.:
A B C D E
1 500 <----
2
3 17
4 75
5 500 <----