View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JPreeshl JPreeshl is offline
external usenet poster
 
Posts: 13
Default multiple column sort in a pivot table

I have a pivot table with names then the count of those names. I want to sort
by the count first then the names. I can only sort by 1 or the other. When I
sort the count column the name column does not sort correctly.
name count
jeff 3
sam 3
adam 3
joe 2
I would like adam to be the first name in the sort. How do I sort both
columns?