Last Value in a Range
Try
=LOOKUP(6.022*10^23,B7:H7)
Mike
"sgl" wrote:
I have the following formula results in a range B7:H7
B C D E F G H
10 25 0 12 0 13 17
I need a formula that will extract the last value in the range that is "17".
These values are claculated from embeded formulas in each cell so even though
columns D and F have a zero value they still have a formula in them
Many thanks/sgl
|