counting single entries where duplicates appear within a specific date range

[xxrichbxx]

I am trying to create a count which will essentially only count a single entry from a range where there could be multiples.

I was looking at a combination of countifs and frequency, but was struggling to get my head around it.

I think that an example of my source data and what I expect to see would give a better understanding of the problem

Week Number Cell ID Date
29 12345 13/07/2020
29 98765 14/07/2020
29 12345 17/07/2020
30 12345 20/07/2020
30 12345 21/07/2020
30 98765 21/07/2020
30 11111 22/07/2020

Summary

Week 29 2
Week 30 3

Hopefully that makes sense.

 

[Fluff]

Do both "Sites" & "Instances" return the same number?

 

[xxrichbxx]

no, the sites pulls in significantly more.

 

[Fluff]

Can you post some data where it is going wrong?

 

[xxrichbxx]

whilst putting something together the function worked.

Again thanks for your help.

I need to put you on speed dial !!

 

[Fluff]

Glad it's sorted & thanks for the feedback.