In M2 withCTRL+SHIFT+ENTER,rather than just ENTER.
=MAX(FREQUENCY(IF(B2:L2="",COLUMN(B2:L2)-COLUMN(B2)+1),IF(B2:L2<>"",COLUMN(B2:L2)-COLUMN(B2)+1)))
Copy down.
In M2 withCTRL+SHIFT+ENTER,rather than just ENTER.
=MAX(FREQUENCY(IF(B2:L2="",COLUMN(B2:L2)-COLUMN(B2)+1),IF(B2:L2<>"",COLUMN(B2:L2)-COLUMN(B2)+1)))
Copy down.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks