Help Sorting and Subsorting
I have attached a spreadsheet I am trying to help a coworker with. We have added four columns to identify the colors for each item. Column AP is a generic tagline for the primary color and AQ is a generic tagline for the secondary color. I am struggling to sort the priorities by AP and then AQ. A0 is the primary color formula and AN is the secondary color formula. Can you help sort the spreadsheet with a priority AP, AQ, AO, and then AN? If you do a custom sort by that priority you will notice it still does not group them properly. I highlighted an example of two items that should be grouped together but have a gap.
|