delete cells according to criteria

[danane]

I've got a table 1 and a table 2. In both tables, there are many entries.
Well, I want to delete all entries in the table 1 that do not exist in table 2. I don't know how I can manage to do this task. Thanks a lot for your help!!!

example:

FIRST:
table 1: table 2:

dog dolphin
cat dog
dolphin bear
donkey tiger
elephant

AFTER:
table 1: table 2:

dog dolphin
dolphin dog
bear
tiger

 

[Chance1234]

Have a look at thread707-1208537 and faq707-6261

Chance,

Filmmaker, taken gentleman and He tan e epi tas