Results 1 to 3 of 3

Thread: Data in page - Excel 2007 / 2010
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2014
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Data in page - Excel 2007 / 2010

    Good Morning

    Currently my client enter data in a sheet for as per the following example:

    Principal/Advisor Mimi 100 000
    Advisor/Associate Erica 50 000
    Principal/Advisor Mimi 100 000
    Advisor/Associate Piet 100 000


    I want to create a table from the names that must look like the following:

    Mimi
    Erica
    Piet

    Please assist with this.

    Regards

  2. #2
    New Member
    Join Date
    May 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data in page - Excel 2007 / 2010

    Hi, use the pivot table

  3. #3
    New Member
    Join Date
    Apr 2014
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Data in page - Excel 2007 / 2010

    Thanks but not to used to Pivot Tables, how do you get this to automatically update when data change for example, 1: Next month their is an extra person with two lines of business and all current people had different income amount?

Some videos you may like

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
  •