Suppose I have the following:
Col A Col B Col C Result
1/7/2015 M 1 0
1/7/2015 M 2 0
2/7/2015 A 1 1
2/7/2015 A 1 1
3/7/2015 C 2 0
I wish to count the number of occurances where col A and Col B and Col C are the same (this would appear in the result column.)
I have used countifs(A$2:A$100,A2,B$2:B100,B2,C$2:C100,C2) as array (ctrl+shift+enter) but I have 100,000+ rows and the copy and calculation is extremely slow.
Does anyone know of a faster way?
Bookmarks