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...
=SUM(BYROW(WRAPROWS(IF(COUNTIF(E1:E5,C5:C500),A5:A500,0),5,0),LAMBDA(x,--AND(x=SEQUENCE(,5)))))