How to return the last non-blank cell in a column that is TEXT
On Mon, 6 Oct 2008 15:14:11 -0700, VSlaybaugh
wrote:
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.
=LOOKUP(2,1/(LEN(D7:D7000)0),D7:D7000)
--ron
|