Find and Return the Non-Blank entry
Hi,
The solution I posted solves the issue provided you are truly returning null
string and not a space.
Paul C solution works even with a space
Nuje
"Art" wrote:
I forgot to mention that cells A1:A4 do contain a formula. All evaluate to an
empty string except for cell A3. I don't think any of the solutions resolve
this issue.
Sorry,
Art
"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
|