ExcelBanter - Pivot Table Sort Issue

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Sort Issue (https://www.excelbanter.com/excel-discussion-misc-queries/251118-pivot-table-sort-issue.html)

Gene Moirao

Pivot Table Sort Issue

Hi
Using Excel 2003 and the field Month (Jan....Dec), moved into the Row area.
Been working fine (special month sort order) for months. Now the months do
now sort "correctly" (Jan....Dec), but sorts Jan...Dec with May and Jun in
the last 2 positions. All other 10 months sort correctly.
?
thanks,
Gene:)

Max

Pivot Table Sort Issue

Maybe its a data issue -- text dates/real dates ?
Check the recent data. Ensure all are real dates.
--
Max
Singapore
---
"Gene Moirao" wrote:
Using Excel 2003 and the field Month (Jan....Dec), moved into the Row area.
Been working fine (special month sort order) for months. Now the months do
now sort "correctly" (Jan....Dec), but sorts Jan...Dec with May and Jun in
the last 2 positions. All other 10 months sort correctly.
?
thanks,
Gene:)

All times are GMT +1. The time now is 12:10 AM.