Last Value in Column
 

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)

Hi katie

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"katie" wrote in message ...
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)

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

--
Don Guillett
SalesAid Software

"katie" wrote in message
...
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)