Thread: How to return the last non-blank cell in a column that is TEXT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VSlaybaugh VSlaybaugh is offline
external usenet poster
  
Posts: 5
Default How to return the last non-blank cell in a column that is TEXT
In any cell of column C of Sheet 2, I want it to return the last non-blank
cell from Sheet 1 Column D...being the last non-blank cell in or ABOVE that
row. Column D in sheet 1 has TEXT and no numbers. My range I'm working from
on sheet 1 is D7:D7000.
Reply With QuoteReply With Quote