Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: merging duplicate information in a column

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a spread sheet that has 12 worksheets (January-December). Each sheet has a column for a name and a column for the person's commission. Some names are in all 12 worksheets, some are in some of the worksheets and some are in only one worksheet.

    I want to combine all of these worksheets into one list and combine the entries that are in multiple worksheets into one entry with their commission added together.

    For example:

    January
    NAME COMMISSION
    john smith $3000
    tom brown $1000
    jim jones $200

    February
    NAME COMMISSION
    john smith $3500
    jim jones $1000

    March
    NAME COMMISSION
    jerry james $500
    tom brown $5000

    The above example would end up looking like:

    NAME COMMISSION
    john smith $6500
    tom brown $6000
    jim jones $1200
    jerry james $500

    Anyone got any idea of how to do this?

    Thanks in advance,

    Alan

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    See the Excel Help topic for "Consolidate data by category".

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I really would like to have someone explain how to do it if possible. The help is very unclear.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-10 10:27, alanf wrote:
    I really would like to have someone explain how to do it if possible. The help is very unclear.
    It's really quite easy. Let's say that A1:B4 contains...

    {"Fruit","Qty"
    ;"Apples",10
    ;"Oranges",20
    ;"Bananas",30}

    ...and A6:B9 contains...

    {"Fruit","Qty"
    ;"Apples",5
    ;"Oranges",15
    ;"Bananas",25}

    Select cell A11, choose the Data | Consolidate... menu command, add the references shown above, check both "Top row" and "Left column", and press [ OK ].

    A11:B14 now contains...

    {"Fruit","Qty"
    ;"Apples",15
    ;"Oranges",35
    ;"Bananas",55}

    [ This Message was edited by: Mark W. on 2002-04-10 10:35 ]

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
  •