Or, as per your parallel post, not sorted by coder:
=IF($G2="","",SUMPRODUCT(((LEN("¦"&SUBSTITUTE($B$2:$C$6,",","¦"))-(LEN(SUBSTITUTE("¦"&SUBSTITUTE($B$2:$C$6,",","¦"),"¦"&$G2,"")))))/LEN("¦"&$G2)))
Or, as per your parallel post, not sorted by coder:
=IF($G2="","",SUMPRODUCT(((LEN("¦"&SUBSTITUTE($B$2:$C$6,",","¦"))-(LEN(SUBSTITUTE("¦"&SUBSTITUTE($B$2:$C$6,",","¦"),"¦"&$G2,"")))))/LEN("¦"&$G2)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks