Thread: Find cell address of last cell in a column with text
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Find cell address of last cell in a column with text
You're Welcome!


"mike in texas" wrote:

Thanks! Works perfectly.

"Teethless mama" wrote:

Try this:

="D"&MATCH(REPT("z",255),D:D)


"mike in texas" wrote:

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