- Take copy of column with duplicated data.
- Paste it anywhere.
- From Data Menu, Select the column you have just pasted and select remove duplicates.
- In another column start to type the below formula :
=COUNTIF(Range of duplicated data, Criteria of counting which in this case you will select the first cell in the column with removed duplications).
Here is a live sample:
- In Cell C2 write this IF condition : =COUNTIF(A:A,B2)