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