ABD3=MAX(FREQUENCY(IF(B3:ABC3=1,COLUMN(B3:ABC3)),IF(B3:ABC3<>1,COLUMN(B3:ABC3))))

for office 365 enter

for other office control+shift+enter

copy down