|
Posted to microsoft.public.excel.misc
|
|
|
Last in a series
See this:
http://xldynamic.com/source/xld.LastValue.html
Biff
"Biocellguy" wrote in message
...
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" wrote:
Or:
=MIN(rng)
If the last number might not be the smallest number:
=LOOKUP(10^10,rng)
Biff
"CLR" wrote in message
...
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
"Biocellguy" wrote in message
...
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
|