Forum Discussion
Solved
Most common column
Hi! I have the below table, and I would like on the last column: to return the column name of the cell with the highest number. If the highest number is in more than one column, it should show th...
It depends on which version of Excel you are, as variant
=TEXTJOIN(", ",1,FILTER($B$1:$D$1,B2:D2=MAX(B2:D2)))
It depends on which version of Excel you are, as variant
=TEXTJOIN(", ",1,FILTER($B$1:$D$1,B2:D2=MAX(B2:D2)))