Forum Discussion
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...
I 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.
Maybe you are hitting one of the limits. Some are discussed here:
https://www.mrexcel.com/excel-tips/custom-list-limits/
