How to get around using Subtotal

  • This is likely a really easy problem, but, I'm not coder.


    I have (what I think is) a pretty simple sorting problem, where I have a list of items in column A, and their count in Column B.
    What I wanted to do was, to Sort the data by Column A, Subtotal, them and then Sort them again so I can arrange their totals from Highest to Lowest.
    This brings up the problem of Sorting after Subtotaling, which is causing my macro to fail, refusing to do the last sort. So how do I get around this?


    Example data before and... after:
    [TABLE="border: 1, cellpadding: 1, width: 500"]

    [tr]


    [td]

    apples

    [/td]


    [td]

    53

    [/td]


    [td][/td]


    [td]

    apples

    [/td]


    [td]

    142

    [/td]


    [/tr]


    [tr]


    [td]

    cherries

    [/td]


    [td]

    15

    [/td]


    [td][/td]


    [td]

    dates

    [/td]


    [td]

    104

    [/td]


    [/tr]


    [tr]


    [td]

    cherries

    [/td]


    [td]

    86

    [/td]


    [td][/td]


    [td]

    cherries

    [/td]


    [td]

    101

    [/td]


    [/tr]


    [tr]


    [td]

    dates

    [/td]


    [td]

    48

    [/td]


    [td][/td]


    [td]

    bananas

    [/td]


    [td]

    30

    [/td]


    [/tr]


    [tr]


    [td]

    bananas

    [/td]


    [td]

    15

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    dates

    [/td]


    [td]

    56

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    bananas

    [/td]


    [td]

    15

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    apples

    [/td]


    [td]

    89

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]

    Thanks in advance,
    Z

  • Hello,


    Would you mind attaching your sample workbook .. along with your expected result ... :wink:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

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