Forum Discussion
Excel formula to count how many times the same 5 names show up with the same date. aka NBA lineup
There are 3 columns a5:500 1-5 repeating every 6th row b5:500 Date which changes every 6th row c5:c500 Player names vary depending on who started. I want find how many times the same 5 play...
Hendew44 Here's a couple more MS365 options to add to the mix...
Using a 2-dimensional COUNTIFS array (by player and date):
=SUM(BYCOL(COUNTIFS(C5:C500, E5:E9, B5:B500, TOROW(UNIQUE(B5:B500))), LAMBDA(c, PRODUCT(c))))
Or simplified with WRAPROWS (by player):
=SUM(BYROW(COUNTIF(E5:E9, WRAPROWS(C5:C500, 5)), LAMBDA(r, PRODUCT(r))))