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