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

nikki115 wrote:
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.



--
nikki115
------------------------------------------------------------------------
nikki115's Profile: http://www.excelforum.com/member.php...o&userid=35221
View this thread: http://www.excelforum.com/showthread...hreadid=549919