List the one nonempty cell
works!
thanks
"RichardSchollar" wrote:
Hi Adam
Maybe:
=LOOKUP(REPT("z",255),B:B)
Hope this helps!
Richard
Adam Graham wrote:
All of column B is empty except one cell. The non-empty cell is in a
different place each week. I want a formula that will give the text in the
nonempty cell, regardless of which cell is nonempty at that point in time.
For example.
Week 4
Cell should say "Text 4"
A B
1
2
3
4 Text 4
Week 2
Cell should say "Text 2"
A B
1
2 Text 2
3
4
Thanks
|