I have two columns, Ad Groups (Column A) and Keywords (Column B)....There are mulitple keywords per column and I need to check to make sure that:

1: The name of the name of the ad group is contained in the keyword list associated to the adgroup
2: and that it isn't associated to any other ad group

For Example:

Ad Group Keyword

Labrador Labrador
Labrador Black Lab
Labrador Yellow Lab
Big Dogs German Shepherd
Big Dogs Bid Dogs
Big Dogs Black Lab

1: 'Labrador' and 'Big Dogs' the adgroups have a corresponding keyword to each.

2: 'Black Lab' the keyword is erroneously assigned to two different adgroups.


That's what I need to check for and I need excel to alert me somehow (highlight, TRUE/FALSE, etc.). The list contains some 220 ad groups and 3500 keywords so its a bit much to do manually.

Thanks,
James