How do I make a cell return the name of a column in a data set, given certain numerical value requirements?
Try this formula:
=INDEX($B$1:$D$1,,MATCH(TRUE,B2:D2<6,))
How do I make a cell return the name of a column in a data set, given certain numerical value requirements?
Try this formula:
=INDEX($B$1:$D$1,,MATCH(TRUE,B2:D2<6,))