Question for those Excel experts!

[dotcomer]

So i have an excel spread sheet. I have a list of cities in column A. In Column H we have a list of cities we already mailed advertisements too. I need to remove the cities we already sent advertisements to from column H, out of column A.

So basically the cities in Column H are our bad cities. Column A is our good.

How do I remove the cities that are in Column H from Column A?

 

[FDibbins]

Also, did you try my suggestion about filtering?

Make sure your entire data range is highlighted (in case there are any empty cells to mess things around)
Click the HOME tab/Editing/Sort and Filter/Filter
you will see all your heading row cells now have a small drop-down in them, click the 1 you want to filter on and uncheck whatever needs to be unselected to show what you need

Once you have that done, you can then do whatever you need to, with the rows that show