Need to sort your data with a bit of a twist? Podcast #1238 shows you how to sort Excel items into a sequence that is neither AZ nor ZA.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel in Depth, chapter 20.
Custom Sorting.
Hey! Welcome back to the MrExcel netcast.
Hi! I'm Bill Jelen. I love this trick.
I used to run into this one all the time.
I have three regions in this country, cut.
Pick up, I have three regions, Central, East and West and I want East to sort first.
So, you see if I come here and to data A-Z, Central comes first.
Z-A, west comes first.
There's no way to hit east to come first and you know this is just a hassle.
You have this all the time.
You have product lists or product lines or you know whatever.
You need to sort it into some special sequence.
So, come out here just to a blank section in spreadsheet, and we're going to teach Excel how to sort, East, Central, West.
Is how I want this to appear.
Type those, choose those cells.
We go to excel options.
Excel options right down here.
Excel options.
It used to be right here, in the first screen of it being excel 2007.
Now, it's hidden back here advanced, scroll down, down, then edit custom list.
Help you can see over there.
Edit custom list.
Alright, and we're going to import our list.
So, there's where, I typed East, Central West .Click [ Import ].
These interests you also could by the way type it here but, for me it's easier to type it in the cells, make sure I get it right.
Click [ OK ]. Alright! Now, excel understands that custom list and is now available to us.
When we sort using this sort dialog.
Alright! So, I'm not going to sort with these two buttons, when I want coming to sort.
So, I want to sort by region, sort on values but instead of A to Z, or Z to A custom list and I wanted to sort it in the East, Central, West sequence. Click [ OK ].
Alright okay! So, then East comes first, followed by Central, followed by West.
Alright! Very easy to set up a custom list.
Once you set up, the custom list.
It works on every workbook, on the computer.
Something would change, you get a new region.
Go back and edit the custom list, allows you to do all kinds of cool things as sorting of course and then also you know the other thing you do is take the first item from the list Grab the fill handle and drag.
Type the remaining items from the list.
So, that's the other benefit of custom list.
But, the big one here in this chapter talking about sorting...
Hey! I want to thank you for stopping by.
Will see you next time for another netcast, from MrExcel.
Excel in Depth, chapter 20.
Custom Sorting.
Hey! Welcome back to the MrExcel netcast.
Hi! I'm Bill Jelen. I love this trick.
I used to run into this one all the time.
I have three regions in this country, cut.
Pick up, I have three regions, Central, East and West and I want East to sort first.
So, you see if I come here and to data A-Z, Central comes first.
Z-A, west comes first.
There's no way to hit east to come first and you know this is just a hassle.
You have this all the time.
You have product lists or product lines or you know whatever.
You need to sort it into some special sequence.
So, come out here just to a blank section in spreadsheet, and we're going to teach Excel how to sort, East, Central, West.
Is how I want this to appear.
Type those, choose those cells.
We go to excel options.
Excel options right down here.
Excel options.
It used to be right here, in the first screen of it being excel 2007.
Now, it's hidden back here advanced, scroll down, down, then edit custom list.
Help you can see over there.
Edit custom list.
Alright, and we're going to import our list.
So, there's where, I typed East, Central West .Click [ Import ].
These interests you also could by the way type it here but, for me it's easier to type it in the cells, make sure I get it right.
Click [ OK ]. Alright! Now, excel understands that custom list and is now available to us.
When we sort using this sort dialog.
Alright! So, I'm not going to sort with these two buttons, when I want coming to sort.
So, I want to sort by region, sort on values but instead of A to Z, or Z to A custom list and I wanted to sort it in the East, Central, West sequence. Click [ OK ].
Alright okay! So, then East comes first, followed by Central, followed by West.
Alright! Very easy to set up a custom list.
Once you set up, the custom list.
It works on every workbook, on the computer.
Something would change, you get a new region.
Go back and edit the custom list, allows you to do all kinds of cool things as sorting of course and then also you know the other thing you do is take the first item from the list Grab the fill handle and drag.
Type the remaining items from the list.
So, that's the other benefit of custom list.
But, the big one here in this chapter talking about sorting...
Hey! I want to thank you for stopping by.
Will see you next time for another netcast, from MrExcel.
