Sorting a subtotalled list?

[dharker]

Hi,

I need to do some analysis on customers calling in asking for support. I have a spreadsheet containing details of the site and the call types etc, and would like to subtotal count the sheet to show where a site has called multiple times. I'm happy with sorting the sheet in site order then subtotalling, breaking on change of site name. This shows the individual support tickets plus a count of tickets which is 90% of what I need.

My question is this, It would be an enormous help if I could then sort the subtotalled sheet in reverse count order so that the highest number of calls is at the top, plus its tickets, and then 2nd largest, third etc etc, each with the tickets associated to that site count.

e.g.
ticket site
0001 London
0003 London
0006 London
0011 London
4 London Count
0002 Manchester
0007 Manchester
0008 Manchester
3 Manchester Count
.
.
.
.

[TMS]

Maybe you could use a Pivot Table.

[dharker]

Is there a decent guide to beginners Pivot tables?
Thanks
David

[TMS]

Recently got this sent to me ... looks like it should help you: http://www.get-digital-help.com/cate...l/pivot-table/

Or Google Excel Pivot Table and get this: https://support.office.com/en-us/art...9-F99134456576

[dharker]

Thanks TMS, much appreciated! I'll give Pivot tables a look...

David

[TMS]

You're welcome.