contact info

  1. L

    Either/Or Options for Filtering (Removing a Contact with No Contact Info)

    Hi there, I am working with a contact list of over 3,000 individuals. I need to remove people from the list who don't have either an address OR email. If they have one or the other, or both they remain on the list. Is this possible? My current method is to use the Ctrl+G option > Go To Special...
  2. J

    Excel internet search engine code

    Hello, I have a list of people for whom I would like to get phone numbers. Instead of searching one by one through the white pages or another phone site, does anyone know of a macro or function that I could enter into excel and provide an "I feel lucky" type search for the phone number? I...
  3. N

    Counting duplicates

    Hello, I have a list of contact information which has a very large number of duplications. I was able to filter it down to unique values, but I've been asked to add a column which states the number of times each entry was repeated in the original list. We want this (each character is a column)...
    • nguindon
    • Thread
    • contact info counting duplicates csv database duplicates
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top