| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Pivot Table sort
Use a helper col to convert the text dates to real dates,
eg: In B2, copied down: = -- A2 where A2 down contains the text dates Then pivot using col B instead of col A, and it'll sort correctly in chrono order (you can format it as date to taste) -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:67 xdemechanik --- "acss" wrote: I am trying to create a pivot table of of some small data and when it is created it unsorts the dates. In my data sheet i have it as January 2008, February 2008,March 2008 etc yet my columns in the pivot are not in that order....how can i place them in the correct order? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Pivot table sort | Excel Worksheet Functions | |||
| Pivot table sort | Excel Worksheet Functions | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Sort pivot table | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Threaded Mode
