Consulting

Results 1 to 2 of 2

Thread: 3 columns matched create report

  1. #1
    VBAX Regular
    Joined
    Feb 2011
    Posts
    34
    Location

    3 columns matched create report

    Hi,
    I have 4 columns [A CODE], [B TAG],[C CUSTOMER],[D AMOUNT] this are all duplicates in the sense of columns A,B,C I want them to group. if all 3 columns matches to more of them then generate report on next sheet with consolidated 4th column of Amount, and duplicates counts occurred

    Any helps.
    CODE TAG CUSTOMER AMOUNT
    002 101 COSMOS 74027.00
    002 101 COSMOS 20718.00
    002 101 COSMOS 136600.00
    002 102 SAM 40000.00
    002 102 SAM 80250.00
    002 102 SAM 1290.00
    003 120 PLUTO 5432.00
    003 120 PLUTO 5674.00
    003 120 PLUTO 9000.00
    009 140 CLICK IT 1450.00
    009 140 CLICK IT 2346.00
    REPORT SHEET
    CODE TAG CUSTOMER TOTAL COUNT
    002 101 COSMOS 231345.00 3
    002 102 SAM 121540.00 3
    003 120 PLUTO 20106.00 3
    009 140 CLICK IT 3796.00 2

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    In the attached, two solutions:
    1. A basic pivot table
    2. A power query solution.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Posting Permissions

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