Find and Return the Non-Blank entry
Try this...
Assumes no cells contain formulas that return formula blanks (which are TEXT
strings):
=LOOKUP("zzzzzz",A1:A4)
--
Biff
Microsoft Excel MVP
"Art" wrote in message
...
_________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
|