Display first cell in the right of range

[miro]

Hi.
Without VBA code, I need to fill in B10 the last cell present in the
range A1:A10 (but not always the cell on the left in range A are fill,
so I cannot use index based on "full cells" minus "empty cells").
I mean that in B10 must be the first fill cell startng from right of
the range A1:A10

ex.
a) If I put in A3 = 445, in A5 = 99 the B10 must have 99
b) If I put in A6 = 45, in A9 = 9 the B10 must have 9
c) If I put in A2 = 45, in A4 = 444, in A9 = 9 the B10 must have
d) If I put in A2 = 45, in A4 = 444, in A9 = 333 the B10 must have 333

Thanks in advance
M.

 

[Carim]

Hi Miro,

Based on Tom's recommendation, give a try to the following formula to
be typed in B10 :
=INDEX(A1:A10,MATCH(9.99999999999999E+307,A1:A10))

HTH
Cheers
Carim

 

[miro]

Thanks a lot, Carim (and Tom)..
M.