Offset??

[tpitman]

Hi,

I need to find the last non zero value in a range of cells in a column, i.e X2:X13. It does not need to be the max or min, so there is no need to sort the range first.

thanks

[VBA Noob]

Hi,

Will this work for you

=LOOKUP(2,1/(X1:X12>0),X1:X12)

VBA Noob