I have 7 columns that contain phone numbers.

I want to remove duplicates across all columns, so that only one occurrence of a phone number will appear across all cells. I don't care which one of the duplicates is removed.

I don't want to remove any rows.

How can I do this?

I could not find a VBA macro that worked.

Thanks!