Forum Discussion
Count unique values among duplicates with condition
I have a large table and am using COUNTIF to show week number and then days of the week and the quantity of vehicles on each day each week (column G is the week number and column E is the visits to a site of all our vehicles.
=COUNTIFS('West Suffolk Out Bound'!$G$2:$G$2921,C$3,'West Suffolk Out Bound'!$E2:$E2921,$B5)
How to I add something so it only counts unique vehicles, not every visit
1 Reply
Try taking a look at this Excel Community Forum Post:
I think it answers your question. There are also a few example files for your reference.
