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

I have a pivot table in which I use to count how many times the same name
appears in a list. In the pivot table I have 2 columns, the name & the number
of times that name appears in my list. I want to sort the columns with the
names appearing the most on top then have the names in ascending order. I can
only sort 1 of the columns. Is there some way to sort by number first then by
the name?
jeff 3
steve 3
art 1
bill 1