Forum Discussion
Solved
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))
This is because it is a two-dimensional range. Convert it to a single column first:
=COUNTA(UNIQUE(TOCOL(A1:Q27,1)))
The second argument 1 in TOCOL makes Excel ignore blank cells.
Thank you so much, I didn't realise unique would only run on a single column/row.