Thanks.
=IF(COLUMNS($A:A)>SUM(0+(FREQUENCY(IF($A2:$L2=1,COLUMN($A2:$L2)),IF($A2:$L2<>1,COLUMN($A2:$L2),0))>0)),"",INDEX($A$1:$L$1,,MATCH(LARGE(FREQUENCY(IF($A2:$L2=1,COLUMN($A2:$L2)),IF($A2:$L2<>1,COLUMN($A2:$L2),0))+1/(10^3*ROW(INDIRECT("1:"&1+COLUMNS($A2:$L2)))),COLUMNS($A:A)),FREQUENCY(IF($A2:$L2=1,COLUMN($A2:$L2)),IF($A2:$L2<>1,COLUMN($A2:$L2),0))+1/(10^3*ROW(INDIRECT("1:"&1+COLUMNS($A2:$L2)))),0)-LARGE(FREQUENCY(IF($A2:$L2=1,COLUMN($A2:$L2)),IF($A2:$L2<>1,COLUMN($A2:$L2),0)),COLUMNS($A:A))))
Regards
Bookmarks