Checking for duplicate items in list

T

TheRobsterUK

If I have a list of items is there anyway to check to see if any of the
are duplicated? I.e. check to see if the same entry has been made mor
than once? The list I have at the moment looks something like this:

Name
-------
Susan
Bob
Michael
Roger
Bob
Anne

So the name "Bob" appears twice, so how do I get Excel to check ever
entry in the list and to see if it appears more than once?

Cheers
-Ro
 
G

Gary''s Student

If you want to just identify them and not remove them, then use conditional
formatting

Formula is =COUNTIF(A:A,A1)>1
 
B

B. R.Ramachandran

Hi,

You can use conditional formatting.

Let's assume that the entries are in column A starting in A2. Highlight the
entries and use one of the following CF formulas depending on what you want.

If you want to identify all duplicate entries, the CF formula is,

Formula Is =COUNTIF(A:A,A2)>1

If you want want to identify only the second and higher occurrences of
duplicate entries, use the following CF formula:

Formula Is = COUNTIF(A2:$A$2,A2)>1

Regards,
B. R. Ramachandran
 
G

Gábor

I use the next on this cases:

copy the column A to column B, so now you get two same column. And now use
the countif formula in column C in every line where you have data in columns
A and B as follows:
=COUNTIF(A:A;B:B)

In column C you will get that how many times you have the actual data in row
A.
If you get number 2 or higher, you find duplicated items.
 
Top