Last Value in Column

K

katie

I have a column of data with random numbers. The number of rows with data
varies depending on another formula. I am trying to write a seprate formula
that will automatically give me the last value in the column no matter what
row it is in.

45, 44, 46, 12, , , , , (Would want it to return 12)
45, 44, 46, 12, 32, 17, 53, , (would want it to return 53)
 
D

Don Guillett

one way of many. This is an ARRAY formula so enter with ctrl+shift+enter
=INDEX(B:B,MAX((B1:B65535<>"")*ROW(INDIRECT("1:65535"))))
 
Top