Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
#3
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
another text to column problem | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |