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.

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

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