Sort data by route and stop order

saraapple

Board Regular
Joined
Feb 3, 2020
Messages
165
Office Version
  1. 2010
Platform
  1. Windows
I have a worksheet with 10 columns of data but I want to sort the data by route and then by stop order:

Book1
AB
1RouteStop
211
312
413
514
621
723
822
924
1031
1133
1232
1334
1443
1542
1641
1751
1852
1952
2052
Sheet1


This is just the first 2 columns but it is possible to apply a sort in excel to give me my results by route and then stop order - like the first one in green, this is correct then it goes out of sequence?

I have no idea what this type of sort would be called so struggling to find any information online.

Thank you
Sara
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
You can simply sort by Route then by stop using the sort button on the data tab.
1614106286523.png
 
Upvote 0
Solution
Thank you.....I have not used that function for years - my brain was thinking formulas and helper columns!
Feels like a silly question now, but sometimes I need a push in the right direction to make sure I don't overcomplicate things thank you :)
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,214,430
Messages
6,119,453
Members
448,898
Latest member
drewmorgan128

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top