Finding duplicate entries within a column

M

mazalam

Hi,

I am trying to find formula that would help me find the duplicate
entries within a column. I am looking for the 1st entry to be tagged as
"Unique" and any subsequent duplicated entries as"Duplicate".

A Unique
B Unique
C Unique
B Duplicate
D Unique
E Unique
A Duplicate


Please e-mail (e-mail address removed) if possible.

Many Thanks,

Mazhar
 
C

Cutter

Assuming your original list if items is in column A starting in row 1

In B2 type: =IF(COUNTIF(A$1:A2,A2)>1,"Duplicate","Unique")

Copy this formula down as far as you need
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Column data comparison - what has been deleted and what has been added 8
HELP: Excel 2010; finding duplicate numbers 5
Limit a field to 3 digits 1 capital letter 1nd 2 numbers 10
Duplicate entry in a column/row 14
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Counting unique instances of a text string 2
Finding Duplicate Entries 14

Top