Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell contents returned
hey there, here's the situation: data range with mixed contents. nemed "Date" col 1 dates column 2 numbers in two separate cells, i wish to add the last entries from wach of the columns. i have tried to use the following but it returns #ref, na, name etc. for the first column =INDIRECT(ADDRESS(MAX((date<"")*ROW(Date)), COLUMN(Date),4)) for the second column: =INDIRECT(ADDRESS(MAX((Date<"")*ROW(Date)), COLUMN(Date)+1,4)) my range has empty cell contents for future use inboth columns, I want to be able to search the contents of each column, and select that last cell in the column with data. thanks -- userofexcel ------------------------------------------------------------------------ userofexcel's Profile: http://www.excelforum.com/member.php...o&userid=37040 View this thread: http://www.excelforum.com/showthread...hreadid=567691 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell contents returned
used the following to solve my question, reminded of KISS ( keep it simple St....) =VLOOKUP(MAX(B1:B30),C1:C30,1) thanks -- userofexcel ------------------------------------------------------------------------ userofexcel's Profile: http://www.excelforum.com/member.php...o&userid=37040 View this thread: http://www.excelforum.com/showthread...hreadid=567691 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) | |||
separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
cell contents | Excel Discussion (Misc queries) |