Hi I am looking for a formula that counts the instances of a name and a criteria in a list and progressively counts them.
example.
Formula
Name Criteria Result
John 1 1
John
John 1 2
Dave 1 1
Dave
Mike 1 1
John 1 3
Dave 1 2
Mike 1 2
Thanks in advance.
JD
Assuming Name is in A, Criteria is in B, place this formula in C
=COUNTIFS($A$1:$A1,A1,$B$1:$B1,B1)
Copy down as far as you need
If you don't want zeros try
=IF(COUNTIFS($A$2:$A2,A2,$B$2:$B2,B2)=0,"",COUNTIFS($A$2:$A2,A2,$B$2:$B2,B2))
Hope this helps.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
Works brilliantly.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks