Last in a series

B

Biocellguy

How do I setup a formula to select the LAST number in a series? In the
series I have conditional formatting so there is an * if the condition is not
met. I need to obtain the LAST number before the *. For example

0.02415
0.0195
0.01185
0.00415
*
*
*
I want it to say 0.00415 but in another column the number could be shifted
like

0.114
0.0499
*
*
*
*
*
*

so I want it to say 0.0499.
The list is to long for IF equations.

Thank you
 
C

CLR

If the "last" number is always the smallest number in the range, as in your
examples, then this would do it........

=SMALL(a:a,1)

Vaya con Dios,
Chuck, CABGx3
 
T

T. Valko

Or:

=MIN(rng)

If the last number might not be the smallest number:

=LOOKUP(10^10,rng)

Biff
 
B

Biocellguy

The last number is not necessarily the smallest. The Lookup function works
great. Thank you. I could not figure out the meaning of that function.
 
Top