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.
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.