Last in a series
 

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

Last in a series
 

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

Last in a series
 

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

Last in a series
 

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

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