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 ...
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)
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