Compare two lists and find common entries

[Hitch75]

Hi guys, I hope someone can help me.

If I have two lists of entries, such as:

(list A)
DOG
CAT
BIRD
HORSE
COW

and

(list B)
ELEPHANT
HORSE
SHEEP
CAT

is there any way to find which entries appear in both lists (HORSE, CAT) and remove them the list B, so that the list B at the end contains only the new entries, which didn't appear in the list A?

I suppose it's not difficult, but have no idea how to do it.

THANX A LOT!

Hitch

[arthurbr]

Have a look here :http://cpearson.com/excel/duplicat.htm#ExtractingUnique

[starguy]

Hi guys, I hope someone can help me.

If I have two lists of entries, such as:

(list A)
DOG
CAT
BIRD
HORSE
COW

and

(list B)
ELEPHANT
HORSE
SHEEP
CAT

is there any way to find which entries appear in both lists (HORSE, CAT) and remove them the list B, so that the list B at the end contains only the new entries, which didn't appear in the list A?

I suppose it's not difficult, but have no idea how to do it.

THANX A LOT!

Hitch

see the file attached