Return Text from a row of 20+ columns
I have a table of about 30 columns. In each row, only one cell of the
30 has text in it. What I would like to do is add a column (say AE)
and have a formula that looks through column AA1:AD1, finds the cell
with text and returns it in AE1.
Maybe this will help:
=LOOKUP(2,1/(AA1:AD1<""),AA1:AD1)
I'm not clear about rows vs. columns in the problem statement, so modify
"AA1:AD1" in the formula as needed.
|