+ Reply to Thread
Results 1 to 5 of 5

Telephone Directory

  1. #1
    Registered User
    Join Date
    05-23-2014
    Posts
    2

    Telephone Directory

    Hi all, this is my issue

    I'm sure after reading some of the answers that I have a pretty simple problem, I just can't figure it out.

    I have 750 names in a telephone list arranged like this column A =First name, B= Last name and C= extension number ie;33339
    what I would like to do is out of this data base that has several people with the same first name, I would like to be able to type for instance "Brenda"

    in Cell A3 and have cell B3 return the last name and C3 return the extension number
    then in A4 the next Brenda with last name and extension number so that if there are 5 "Brenda's" they all come up on the screen

    Thanks in advance

    Terry

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Telephone Directory

    Probably it is easier to use a filter for this kind of work.

    Filter on "Brenda" in column A.

    excel 2007 and further: data => filter
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,698

    Re: Telephone Directory

    Take a look at this.
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    05-23-2014
    Posts
    2

    Re: Telephone Directory

    Perhaps I didn't explain this correctly, this is an example of what I am after
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Telephone Directory

    @tnels79

    Take a good look at the attached file of popipipo in #3.

    It is very usefull for your problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Telephone directory
    By tnels79 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-25-2014, 08:34 PM
  2. [SOLVED] How to Arrange telephone directory ocr image in excel, in table form
    By Inqusitive mind in forum Excel General
    Replies: 12
    Last Post: 01-17-2014, 01:59 PM
  3. How to Arrange telephone directory ocr image in excel, in table form
    By Inqusitive mind in forum Tips and Tutorials
    Replies: 1
    Last Post: 01-09-2014, 02:51 PM
  4. Replies: 0
    Last Post: 09-05-2013, 10:00 AM
  5. How do i make a telephone directory for the office
    By Anil in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-20-2006, 05:15 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1