Excel Duplicates

There are two columns (Name – column A, Number- column B). I need to remove all duplicates except for one. However, if there is ‘Bob’ in column A and ‘12345’ in column B… but then in another row there is ‘Bobby’ in column A and ‘12345’ in column B… I still want to remove that duplicate because technically it is the same person, just different nickname. Is there a way to do this?

By: sabrina

One thought on “Excel Duplicates

  1. ig

    May I simply say what a comfort to discover somebody that truly understands what they’re discussing
    over the internet. You actually realize how to bring a problem to light and make it important.

    More people should look at this and understand this side of your story.
    It’s surprising you aren’t more popular because you most certainly possess the gift.

Comments are closed.