How to return the last value from a range

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hello,
I have 48 rows .... one for each half-hour of the day.
I have a cell that needs to reflect the last number
entered in those 48 rows.
An abbreviated example:
a1 = 123
a2 = 234
a3 = 456
a4 = 100
a5 = blank
a6 = blank

b1 = 100 ( the last value in my a1 thru a6 range )
Thank you for your help in advance.
 
If the values are contagious with no blanks in-between

=INDEX(A:A,COUNTA(A:A))

if there can be blanks but the values are numeric

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A)

if there can be text and numeric and blanks

=INDEX(A:A,SUMPRODUCT(MAX((A1:A10000<>"")*ROW(INDIRECT("1:10000")))))


--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Back
Top