Cell | Formula | B1 | =SUMPRODUCT(--(FREQUENCY(MATCH(String,String,0),ROW(INDEX(A:A,1):INDEX(A:A,COUNTA(String))))>1)) | B2 | =SUMPRODUCT(--(FREQUENCY(MATCH(String,String,0),ROW(INDEX(A:A,1):INDEX(A:A,COUNTA(String))))>1)) | B3 | =SUMPRODUCT(--(FREQUENCY(MATCH(String,String,0),ROW(INDEX(A:A,1):INDEX(A:A,COUNTA(String))))>1)) | B4 | =SUMPRODUCT(--(FREQUENCY(MATCH(String,String,0),ROW(INDEX(A:A,1):INDEX(A:A,COUNTA(String))))>1)) | B5 | =SUMPRODUCT(--(FREQUENCY(MATCH(String,String,0),ROW(INDEX(A:A,1):INDEX(A:A,COUNTA(String))))>1)) | B6 | =SUMPRODUCT(--(FREQUENCY(MATCH(String,String,0),ROW(INDEX(A:A,1):INDEX(A:A,COUNTA(String))))>1)) |
|
Bookmarks