Counting repeats from one date to the next

[wknight7]

Hello-
I have a report with 3 columns:

• Column A- date
• Column B- employee name
• Column C- a reference number that basically corresponds to work they need to complete.

So if employee Bob has reference number 123 on 2/12/24, and then again 2/28/24, this would indicate to me that Bob didn't do what he was supposed to.

I am trying to create a formula that will count those instances when there is a repeat from one date to the next. Any help would be appreciated. Thanks!

 

[Joe4]

Couldn't use just use a COUNTIFS formula, counting all the instances where column B and C are the same, and check if the value is greater than 1?
See: COUNTIFS Function

 

[wknight7]

Thank you, that got me thinking in the right direction and I was able to get what I need.

 

[Joe4]

You are welcome.
Glad to hear it helped!