Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-27-2016, 09:13 AM
lonniepoet lonniepoet is offline Help Sorting and Subsorting Windows 7 32bit Help Sorting and Subsorting Office 2013
Advanced Beginner
Help Sorting and Subsorting
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default 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.
Attached Files
File Type: zip Copy of Any Dark.zip (964.6 KB, 14 views)
Reply With Quote
 

Tags
sort worksheet, sorting



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Sorting and Subsorting Sorting texascpa Excel 1 07-15-2015 12:22 AM
Help Sorting and Subsorting Sorting Challenge gbaker Excel Programming 11 06-22-2012 09:39 AM
Sorting by certain criteria randenius Excel 2 06-11-2012 02:18 AM
sorting problem gsrikanth Excel 4 02-16-2012 12:30 AM
Help Sorting and Subsorting Sorting question markg2 Excel 4 01-25-2010 03:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft