View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default How to return the last non-blank cell in a column that is TEXT

Assuming there are no formula blanks in the range:

=LOOKUP(REPT("z",255),D7:D7000)

--
Biff
Microsoft Excel MVP


"VSlaybaugh" wrote in message
...
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.