+ Reply to Thread
Results 1 to 6 of 6

Convert qty of matrix items to matrix groups

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Convert qty of matrix items to matrix groups

    Hi,
    im looking to condense a report! Im sure its possible but just cant figure out how! so i have a report of qty of matrix items (one item but different colours and different sizes) and i need to condense it down.
    so on the attached sheet - i need the quantity of all the cheryls, the quantity of all the Celias and Carries etc.
    any ideas? MANY thanks in advance
    Carol
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Convert qty of matrix items to matrix groups

    Try...
    In F2:
    =SUMIF($A$2:$A$17,E2&"*",$B$2:$B$17)

    Copy down.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2019; 365
    Posts
    231

    Re: Convert qty of matrix items to matrix groups

    In F2 add the following formula and drag down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Ooops, looks like I was a tad slower

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Convert qty of matrix items to matrix groups

    Or do the same referencing whole columns.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  5. #5
    Registered User
    Join Date
    09-27-2012
    Location
    Northampton, England
    MS-Off Ver
    excel 2016
    Posts
    64

    Re: Convert qty of matrix items to matrix groups

    THANK you so much guys it did it

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Convert qty of matrix items to matrix groups

    You are welcome. Glad to help and thank you for the feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. [SOLVED] 9 Cells Matrix / GE Matrix chart hellp
    By vani2004 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-20-2018, 02:34 PM
  2. Matrix Multiplication in VBA and storing values in another matrix
    By anwid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-06-2018, 06:23 AM
  3. [SOLVED] VBA to convert a coloured matrix into an equivalent matrix of 1's and 0's
    By The_Snook in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-27-2017, 01:12 PM
  4. Replies: 2
    Last Post: 11-05-2014, 03:41 AM
  5. Eigenvector of matrix for nxn matrix of variable size
    By rocketscientist165 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2014, 10:51 AM
  6. Replies: 2
    Last Post: 02-11-2014, 05:05 AM
  7. Using a transition matrix as input to a cummulative matrix
    By Walter12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 04:19 AM

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