Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've got a pivot table. The first Attribute (row) generally has 3 characters
for each data point (they are stock tickers) I am sorting alphabetically on that field. It works fine, BUT the first 3 entries are SUN, MAR, and MAY... After that it sorts fine. I'm guessing that somehow excel is guessing these are date abbreviations or part of a custom list although they are simply tickers. Anyone have any ideas?? (ps already validated there's no extra spaces in on any of those data points) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Need help sorting pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Problems with sorting a pivot table | Excel Discussion (Misc queries) |