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.
|