avoiding dupicate keywords

[xor0]

When adding more keywords to a campaign in a new ad group, anyone have a simple way to avoid adding kws that are already in other ad groups in the campaign?

Is there any way to check for duplicates across existing ad groups?

Thx

[skibum]

If you have the old and new lists in Excel you can use the VLookup feature. Put a 1 or something next to all keywords in one of the lists

Put the VLookup formula in the cell next to the first keyword in the other list.

=vlookup(click on first cell you want to check against the old list, highlight the columns you want to check it against in another sheet, type the number of the column you want to appear, type FALSE)

If your keywords are in column A and you put a 1 (or anything for that matter in column B, the the number for this: "type the number of the column you want to appear" will be 2.

Copy that formula all the way down to the end of your keyword list and the resulting cells with a 1 in them next to the keyword list will be your dups.

[eWhisper]

You can also use conditional formatting to highlight the 2nd occurence of a word in a document.

=COUNTIF($B$1:$B1,B1)>1

(change the 'b' to the proper column you're working with)