Last in a series

[Guest]

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

 

[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. Valko]

Or:

=MIN(rng)

If the last number might not be the smallest number:

=LOOKUP(10^10,rng)

Biff

 

[Guest]

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.

 

[T. Valko]

See this:

http://xldynamic.com/source/xld.LastValue.html

Biff