Forum Discussion
Count of duplicates in a column
Good morning! Is there a formula that can be used to give me a count of duplicate values in a column? To be clear, I'm not trying to count known duplicate values that I can include in a C...
If you want the number of unique entries:
=COUNTA(UNIQUE(D3:D12))
If you want the number of entries that occur more than once:
=SUM(--(COUNTIF(D3:D12,UNIQUE(D3:D12))>1))
If you want the number of unique entries:
=COUNTA(UNIQUE(D3:D12))
If you want the number of entries that occur more than once:
=SUM(--(COUNTIF(D3:D12,UNIQUE(D3:D12))>1))
- Thank you for your help.
