Hello,
I am a newbie in this group, if this is an already covered question,
please send me to a FAQ
I have two lists. I want to know which elements from list A are
duplicated AND belong to list B.

Can you tell me how do I do this in Excel?

Thanks,

Miguel

Check out:

http://www.cpearson.com/excel/duplic...tingDuplicates

Pearson's site is as good as any FAQ list you could find.
--
Gary's Student


"M.A.A.C" wrote:

Hello,
I am a newbie in this group, if this is an already covered question,
please send me to a FAQ
I have two lists. I want to know which elements from list A are
duplicated AND belong to list B.

Can you tell me how do I do this in Excel?

Thanks,

Miguel

Thanks a lot, this was very helpful... this is a lot of information and
I will need some time to digest it :-D

Miguel


Gary''s Student ha escrito:

Check out:

http://www.cpearson.com/excel/duplic...tingDuplicates

Pearson's site is as good as any FAQ list you could find.
--
Gary's Student


"M.A.A.C" wrote:

Hello,
I am a newbie in this group, if this is an already covered question,
please send me to a FAQ
I have two lists. I want to know which elements from list A are
duplicated AND belong to list B.

Can you tell me how do I do this in Excel?

Thanks,

Miguel