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