Concatenate formula
I'm trying to get a formula using concatenate that will identify numbers in a
row 3 (4&5) and returning the name of the column above into one cell.
Big small large larger
1 4 5 2
So in one cell I should get [small, large]
I can get this when only looking at one cell but not when Im trying to look
a multiple ones.
|