Forum Discussion
How to count duplicates ... sort of ...
Greetings! Here is part of a table that I am working on: RepairID ModelID Serial Number Date Started Date Tested ReportedSymptom SPEA-1010 PT206 8FA552 10/22/2025 10/2...
If i correctly understand 7 is the result for the sample dataset.
=SUMPRODUCT(1/COUNTIFS(C2:C9,C2:C9,F2:F9,F2:F9))