I have a project sheet that I am wanting to use to arrange projects by priority. My 5 priorities are "N/A, Done, Low, Med., High". These priorities are available in a drop down list and show up color coded when selected. That part...I've got. I want to be able to sort without using a custom sort. Using a custom sort would require everyone else to learn to use custom sort...and that is more difficult than anything excel has to offer. Lol.
I want to sort A-Z or Z-A and have these values fall in by priority. The way I would imagine it to work is that "N/A" = 1, "Done" = 2, "Low" = 3, "Med." = 4, "High" = 5
The question would be: How do I make my sheet sort by #'s 1-5 but show "N/A, Done, Low, Med., High"?
Bookmarks