Find and Return the Non-Blank entry
Yes, but the number of rows in the column will vary. That's another problem I
have which I'm going to post now.
--
Art
"Rick Rothstein" wrote:
Given the conditions you stated, it seems this should work...
=A1&A2&A3&A4
--
Rick (MVP - Excel)
"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
.
|