• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting duplicates

Lilith

New Member
I am trying to count down
Column A
Chris 10/16/2017
Chris 10/20/2017
Allison 10/16/2017
Allison 10/17/2017
Allison 10/18/2017
 
I need to show in Column C for each row that Column A has a 1 for each duplicate that is different by column B.
I need to show in Column C
1
1
1
2
3
 
I need to show that Chris has a 1 for both C1 and C2 since the dates are different but the name is the same. It needs to see both Column A and Column B
 
I just figured it out. I need to use this formula =COUNTIFS($A$1:A1,A1,$B$1:B1,B1) it will give me a 1 for each first occurrence and a 2 or more for each duplicate.
 
Back
Top