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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks