Thread: Find cell address of last cell in a column with text
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Find cell address of last cell in a column with text
Hi,

You may also try to use the following array formula

="A"&MAX(IF(ROW($A$1:$A$11)*(A1:A11<""),ROW($A$1: $A$11)))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"mike in texas" wrote in message
...
Is it possible to return the address of the last non empty cell in a
column.
I've found lots of ways to return the value of the last cell, but I need
the
address e.g. D234.

Thanks

Mike

Reply With QuoteReply With Quote