Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: List of phone numbers

  1. #1
    New Member
    Join Date
    Feb 2013
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default List of phone numbers

    I have a list of phone numbers, names and addresses. This is data from a charity I volunteer for. Each phone number has an associated address and there can be more than one donor names associated with that phone number (& address). Each phone number can be appearing multiple times depending on the number of donations made.
    I want to make a list out of this which will have give me for each donor their name, phone number and address. If there were four members of a family donating, then this list should give me four names in four rows with the same phone number and address.
    All help extremely appreciated.

  2. #2
    MrExcel MVP Robert Mika's Avatar
    Join Date
    Jun 2009
    Location
    (current) UK, (origin) Poland
    Posts
    7,256
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: List of phone numbers

    Quote Originally Posted by munda View Post
    I have a list of phone numbers, names and addresses. This is data from a charity I volunteer for. Each phone number has an associated address and there can be more than one donor names associated with that phone number (& address). Each phone number can be appearing multiple times depending on the number of donations made.
    I want to make a list out of this which will have give me for each donor their name, phone number and address. If there were four members of a family donating, then this list should give me four names in four rows with the same phone number and address.
    All help extremely appreciated.
    Hello and welcome to MrExcel.
    Coudl you post your sample?
    Please see below how to do it
    - Read the Posting Guidelines, Forum Rules & FAQs
    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste
    - If posting vba code, please use Code Tags .

  3. #3
    New Member
    Join Date
    Feb 2013
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: List of phone numbers

    Thank you Robert. I am new to online forums. Please excuse my etiquette and method.
    Here is a sample of data. I am using excel 2007 and windows 7 Ultimate.
    I hope this way of presenting the sample data will work.
    Munda
    Last edited by Peter_SSs; Feb 23rd, 2013 at 11:53 PM. Reason: Table removed

  4. #4
    Board Regular
    Join Date
    Feb 2011
    Posts
    547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: List of phone numbers

    It seems that you have all the appropriate data above. Is the problem that the data is duplicated in your original data? If so, please see this link.

    Remove Duplicates in Excel 2007 | Contextures Blog

    Be sure to use this on a COPY of your original data. You should also delete any data such as dates or donation amounts that you do not want in your final list.

    Cheers,

  5. #5
    New Member
    Join Date
    Feb 2013
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: List of phone numbers, removing duplicates

    Quote Originally Posted by shawnhet View Post
    It seems that you have all the appropriate data above. Is the problem that the data is duplicated in your original data? If so, please see this link.

    Remove Duplicates in Excel 2007 | Contextures Blog

    Be sure to use this on a COPY of your original data. You should also delete any data such as dates or donation amounts that you do not want in your final list.

    Cheers,
    Hello Shawnhet:
    Thank you for the reply. I have a problem using this method. It removes ALL duplicates. I want to delete duplicate names that are tied to one phone number.
    It removes Rajinder that occurs against two phone numbers. Same is the case with Jasbir.

    I hope this explains the situation.
    Last edited by Peter_SSs; Feb 23rd, 2013 at 11:54 PM. Reason: Table removed

  6. #6
    Board Regular
    Join Date
    Feb 2011
    Posts
    547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: List of phone numbers, removing duplicates

    I don't use Excel 2007 myself but I believe that it does do what you want here you just have to be sure to select *all* the fields that you are concerned with.

    Let Excel 2007's new Remove Duplicates feature find unique values in your data | TechRepublic

    "You can also use Remove Duplicates to produce a list of unique values for more than one field. For example, to generate a list of customers and the products they ordered, follow these steps:

    1. Select the Customer Name and Product Name columns.
    2. Copy the selected data to a blank area of the worksheet.
    3. Click inside any cell within the copied cells.
    4. Click the Data tab.
    5. In the Data Tools group, choose Remove Duplicates, then click OK.

    Excel generates a list of each customer and the products ordered, excluding duplicate orders for the same product from the same customer. You can then use the Sort function to make the list easier to read by following these steps:"

    For you, you should be clicking all of these columns F NameM NameL/NameAddressCityP.codePhone #F Name (and not just the Customer and Product NAmes per the example).

    Cheers,

  7. #7
    New Member
    Join Date
    Feb 2013
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: List of phone numbers, removing duplicates

    Thank you Shawnhet.
    It works the way I want it to.
    Cheers

  8. #8
    Board Regular
    Join Date
    Feb 2011
    Posts
    547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: List of phone numbers, removing duplicates

    Terrific. Have a good one!

  9. #9
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    34,831
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    1 Thread(s)

    Default Re: List of phone numbers

    munda

    Welcome to the MrExcel board!

    I have removed the tables from your posts since I wasn't sure if they may have contained real names, addresses and phone numbers. If that was the case, the owners may not appreciate having that data openly available on the internet. If you post such data in the future, make sure it is dummy data and also state in your post that it is not real. That way we moderators will know and won't need to remove it.
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007, 2003 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules & Forum Use Guidelines

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com