Sorting in Excel 2000 Pivot Tables
In an Excel 200 Pivot Table I have a column of text data which appears as
follows: P1-10, P1-2, P1-20, P1-5. Is there anyway I can re-sort this data so that it appears as follows: P1-2, P1-5, P1-10, P1-20. Thx, -- LPS |
Sorting in Excel 2000 Pivot Tables
How about change the underlying data to look more like:
p1-02 p1-05 p1-10 p1-20 Then your sorting will become much easier. LPS wrote: In an Excel 200 Pivot Table I have a column of text data which appears as follows: P1-10, P1-2, P1-20, P1-5. Is there anyway I can re-sort this data so that it appears as follows: P1-2, P1-5, P1-10, P1-20. Thx, -- LPS -- Dave Peterson |
All times are GMT +1. The time now is 02:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com