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...
Apply this formula:
=COUNTA(UNIQUE(TRIMRANGE(CHOOSECOLS(A2:F10, {3,6})))) / 2
HTH
Regards,
IlirU