Have a look here for lots of methods

http://www.cpearson.com/excel/Duplicates.aspx

Mike

"AkTolga" wrote:

Hi,

I have a database; column A contains names and i want to check all the names
( 10.000 rows ) with column B which can contain same names and additionally
new names. So I want to combine column A with column B to create a new
database...
Is there any formula to find duplicated names?

Thanks

AkTolga