How to find duplicate in excel

[rajeshsingh]

Hi,

Need help.

I want to find duplicate values in two columns of excel (2007) sheet. Each cell of data are as mentioned below

ID /Name
BOM12378 /AAA
BOM34987 /BBB
BOM03629 /CCC
IND01643 /DDD
IND34961 /EEE

There are over 4000 cells containg data in the same fashions. How to find duplicates?

Thanks in anticipation
<!-- / message --><!-- edit note -->

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=577458

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).