Is there a way to do an arbitrary sort order on a specific cell?

For example, let's say I have a cell "colour".
Possible values:
1. blue
2. cyan
3. green
4. orange
5. red
6. silver

I want to sort on this cell, BUT, I want the order to show all

red first
blue second
green third
  ... blah ...


__________ Information from ESET NOD32 Antivirus, version of virus signature 
database 5115 (20100514) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333700
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to