Forum Discussion
tlene8
Aug 10, 2023Copper Contributor
Sorting a pivot table in specified order. Not alphabetically or numerically.
I do about 30 employee time cards every week, so the job #'s are constantly changing. We need this info to know how much to charge our customer per job that is done based off of the hours th...
Detlef_Lewin
Aug 10, 2023Silver Contributor
Either create a custom list or move the values in with the mouse.
- tlene8Aug 10, 2023Copper ContributorI have tried to make a custom list, but it does not sort in the order that I tell it to. Is there formula's or words such as 'contains' or 'exact' that I can add to the list to make sure it pulls the correct information? As stated above, when I made the custom list, where the 'SS' job's go, it was pulling the word 'SHOP'. And for 'R' jobs it was also pulling 'RC' jobs.
- Detlef_LewinAug 10, 2023Silver Contributor
Maybe you are hitting one of the limits. Some are discussed here:
https://www.mrexcel.com/excel-tips/custom-list-limits/