ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sort 2 different columns in pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/191633-sort-2-different-columns-pivot-table.html)

JPreeshl

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


All times are GMT +1. The time now is 04:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com