If I have a list of items is there anyway to check to see if any of them
are duplicated? I.e. check to see if the same entry has been made more
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 every
entry in the list and to see if it appears more than once?

Cheers
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=483996

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

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


"TheRobsterUK" wrote:


If I have a list of items is there anyway to check to see if any of them
are duplicated? I.e. check to see if the same entry has been made more
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 every
entry in the list and to see if it appears more than once?

Cheers
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=483996

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

"TheRobsterUK" wrote:


If I have a list of items is there anyway to check to see if any of them
are duplicated? I.e. check to see if the same entry has been made more
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 every
entry in the list and to see if it appears more than once?

Cheers
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=483996

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.



"TheRobsterUK" wrote:


If I have a list of items is there anyway to check to see if any of them
are duplicated? I.e. check to see if the same entry has been made more
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 every
entry in the list and to see if it appears more than once?

Cheers
-Rob


--
TheRobsterUK


------------------------------------------------------------------------
TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924
View this thread: http://www.excelforum.com/showthread...hreadid=483996