Find and Return the Non-Blank entry
even simpler, I misread your post and believed there were numbers in the
other cells
=LOOKUP(2,1/(A1:A4<""),A1:A4)
Mike
"Mike H" wrote:
Art,
Try this
=LOOKUP(2,1/(ISTEXT(A1:A4)),A1:A4)
Mike
"Art" wrote:
_________A
1_________
2_________
3_______Hello
4_________
5_______Hello
I have a single column range (A1:A4). One and only one of the cells contains
a text entry (cell A3 in this example). I want to enter a formula into A5
that will return this text entry.
Thanks,
Art
|