Last Value in Column

[Guest]

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)

 

[Ron de Bruin]

Hi katie

See Bob's site
http://www.xldynamic.com/source/xld.LastValue.html

 

[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"))))