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