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

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

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

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

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