Nov 22 2021 09:29 AM - edited Nov 22 2021 11:58 AM
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 COUNTIF formula, such as =COUNTIF(A:A),"Specific Text". I'm looking for Excel to simply count how many times it sees a duplicate of any kind. See attached.
Nov 22 2021 12:14 PM
SolutionIf 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))
Nov 22 2021 12:14 PM
SolutionIf 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))