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"]
apples
[/td]53
[/td]apples
[/td]142
[/td]cherries
[/td]15
[/td]dates
[/td]104
[/td]cherries
[/td]86
[/td]cherries
[/td]101
[/td]dates
[/td]48
[/td]bananas
[/td]30
[/td]bananas
[/td]15
[/td]dates
[/td]56
[/td]bananas
[/td]15
[/td]apples
[/td]89
[/td]
[/TABLE]
Thanks in advance,
Z