I have a list of customers who had a specific account with my company that don't anymore and another list of customers who were charged off. The first list includes customers who were both good and left and were charged off. I want to take out all of the names in the first list that appear in the second list.
If possible, I'd like it to delete the entire collumn from the first list. I'm guessing I would have to have the names on seperate sheets in order to do this? If that's not a choice, then I would like to have the names in the first list highlighted so I could manually delete them.
Anyone know of how I could do this?
Bookmarks