Forum Discussion
Solved
Formula to select relevant heading based on 2 conditions
Trying to select the relevant heading an array. Effectively, return first heading where there is either an "x" or "z". So in the example below would return 4H
| 2H | 4H | 8H | 1D | 2D | 1W |
| a | b | x | |||
| a | b | x | x | ||
| a | z | x | x | ||
| c |
JohnDatacom There's likely more than one way to achieve this. If you have Excel for MS365, here's one option:
=TAKE(TOCOL(IFS((A2:F5="x")+(A2:F5="z"), A1:F1), 2, TRUE), 1)
Hi,
You can use =OR(ISNUMBER(MATCH("x",A2:A5,0)),ISNUMBER(MATCH("z",A2:A5,0))) to check whether or not the column has "x" or "z".
Then you can use INDEX and MATCH to find out the heading of the first column that satisfies this condition.
JohnDatacom There's likely more than one way to achieve this. If you have Excel for MS365, here's one option:
=TAKE(TOCOL(IFS((A2:F5="x")+(A2:F5="z"), A1:F1), 2, TRUE), 1)djclements thank you that worked perfectly. Appreciated
