Sorting in Excel

Sorting in Excel
My manager demanded that the reports be sorted into East, Central, West sequence. I was stuck. Unless I could convince him to rename the "East" region to be called "Middle", there was no good way to get the regions to sort into the correct sequence. Luckily, Excel offers custom sort sequences and they are pretty easy to set up.

It may sound crazy, but sometimes you need a random sort. If you are a teacher and need to figure out an order for your students to present their book reports, perhaps assigning them randomly is more fair than alphabetically.

Both of these topics, plus one-click sorting are the topic of my June 10, 2005 appearance on Call for Help. Visit http://www.mrexcel.com/tip093.shtml for the show notes.