I have customer support case data like this:
Customer Time Account_A 90 Account_A 45 Account_B 25 Account_B 90 Account_B 35 Account_C 100 Account_C 120
How would I summarize by customer name, doing a sum of time spent, and then sort the summary lines by time spent?
So my end result looks like this:
Customer Time Account_C 220 Account_B 150 Account_A 135
I used the subtotal function in Excel 2010, and then hid the details, but that only got me the summaries, I couldn't sort by the summaries, nor could I figure out how to copy just the summary lines into a fresh sheet and sort them there.