Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/mwexler/public_html/tp/textpattern/lib/txplib_db.php on line 14
The Net Takeaway: Custom Sort Order in Excel...


Danny Flamberg's Blog
Danny has been marketing for a while, and his articles and work reflect great understanding of data driven marketing.

Eric Peterson the Demystifier
Eric gets metrics, analytics, interactive, and the real world. His advice is worth taking...

Geeking with Greg
Greg Linden created Amazon's recommendation system, so imagine what can write about...

Ned Batchelder's Blog
Ned just finds and writes interesting things. I don't know how he does it.

R at LoyaltyMatrix
Jim Porzak tells of his real-life use of R for marketing analysis.






Custom Sort Order in Excel... · 05/31/2005 12:15 PM, Tech

Seen in the Lockergnome collection of tech resources (some good stuff here, by the quasi-famous Chris Pirillo).

By Diana Huggins, orginially published here:

You can instruct Excel to sort the data in a worksheet. If the sorting orders within Excel do not meet your requirements, you can create your own sorting order. For example, if you type in Red, Green, Blue, and Black, Excel would normally sort them in alphabetical order. However, if you do not want them sorted this way, you can create your own custom sort order by completing the steps listed below:

  1. Within Excel, click Tools and click Options.
  2. Select the Custom Lists tab.
  3. Under Custom Lists, verify that NEW LIST is highlighted.
  4. In the List Entries field, start typing in your list elements in the order they should be sorted. Make sure you press Enter after each element.
  5. Once you have typed in all the elements, press Add.
  6. Click OK.

You can now use the special sort order to sort your data. Select the cells that contain the data you want to sort. From the Data menu, click Sort. Select the Options button. Use the drop down arrow to select the sort order you created in the previous steps. Click OK. Click OK to close the Options dialog box.

* * *


  Textile Help
Please note that your email will be obfuscated via entities, so its ok to put a real one if you feel like it...

powered by Textpattern 4.0.4 (r1956)