Return column header by comparing multiple row values conditions

Originally Posted by aschom

If more than one column is still tied return multiple column headers.

It would be almost impossible to do that in one cell using formulas.......but you could do that in multiple cells:

Put this formula in D26

Formula:

=IFERROR(INDEX($C2:$L2,SMALL(IF(($C24:$L24=MAX($C24:$L24))*($C22:$L22=$A22&$B22)*(MIN(IF(($C22:$L22=$A22&$B22)*($C24:$L24=MAX($C24:$L24)),ABS($C23:$L23-$B23)))=IF(($C22:$L22=$A22&$B22)*($C24:$L24=MAX($C24:$L24)),ABS($C23:$L23-$B23))),COLUMN($C2:$K2)-COLUMN($C2)+1),COLUMNS($D26:D26))),"")

confirm with CTRL+SHIFT+ENTER and copy across to G26 or further depending on the maximum possible ties there might be.

If there is only one winner after the second tie-break then that will put that winner in D26 and leave the other cells blank. If there are 2 or more winners it will list those in D26, E26 etc.

See attached example where I changed the values so that Matt and Dillon are tied - change C23 to 92 or 90 and see how that changes the result....