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

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