LinkBack URL
About LinkBacks
Try this formula, entered as an array (CNTRL SHFT + ENTER)
=MAX(FREQUENCY(IF(B2:AM2="N",COLUMN(B2:AM2)-1),IF(B2:AM2<>"N",COLUMN(B2:AM2)-1)))
Does that work for you?
Try this formula, entered as an array (CNTRL SHFT + ENTER)
=MAX(FREQUENCY(IF(B2:AM2="N",COLUMN(B2:AM2)-1),IF(B2:AM2<>"N",COLUMN(B2:AM2)-1)))
Does that work for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks