Finding duplicate values b/w two columes

[nikki115]

Is there any way i can find duplicate cells between two columes.

i have to see these duplicate value in lots of columes it will take a
long time to do it manually.

 

[paul.robinson]

Hi
Try searching this newsgroup with "find duplicate values in two
ranges". You should find something useful. Anything by Tom Ogilvy
especially, on this kind of thing, is sure to be neat as he probably
has a simple worksheet function that will do what you want.

regards
Paul

 

[Dave Peterson]

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm