Match and subtotal multiple columns of data by name

  • I have attached my example workbook. I need a way to look in multiple columbs for multiple names, then when found, add together all instances of the names value in a totals box.

    i.e 100 John 200 Bill
    200 Bill 500 john
    300 Sam 150 sam

    Then keep a running total of the numbers beside thier name.forum.ozgrid.com/index.php?attachment/33194/

  • Re: Match and subtotal multiple columbs of data by name


    There are a few issues with your original data.

    Pac hoe and pac hoe will need special handling to be matched to Pac-Hoe
    simmons needs special handling to be matched to Simmons
    triage t and triagle t needs special handling to be matched to Triagle T

    These kind of 'fuzzy' maches make the formulas far more complex and may require VBA depending on the degree of difference between the Vendor name as it appears in the original data and the match string being used for the totals.

    Also, is it possible to re-arrange your data so that it is in a single table with Tons in one column and Vendor in another?

  • Re: Match and subtotal multiple columbs of data by name





    Thank you so much this works exactly the way i needed it to. I still new to excel and i tried a vlookup and hlookup with no luck. I will look more into arrays. thanks again. have a great day!

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!