Any insight would be greatly appreciated.
B Biff Oct 26, 2006 #2 Try this: =LOOKUP(REPT("z",255),A:A) Will return the last TEXT entry in column A. Biff
B Bob Phillips Oct 26, 2006 #3 =LOOKUP(2,1/(A1:A200<>""),A1:A200) will find number or text -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=LOOKUP(2,1/(A1:A200<>""),A1:A200) will find number or text -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
