Finding duplicate values b/w two columes
 

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.
:confused:


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

Finding duplicate values b/w two columes
 

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.
:confused:


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

Finding duplicate values b/w two columes
 

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

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.
:confused:

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

--

Dave Peterson