Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort other than by alphabetical ascending/ descending
I've got 3 values: High, Medium, Low. How can I sort my table by all "High"
items first, followed by "Medium" items, then by "Low" items? I can't use alphabetical sorting coz either ascending or descending order won't work. |
#2
|
|||
|
|||
one pedestrian way is to have anoter column which designates high as
A,medium as B and low as C. you can use <iffunction for this. and then sort according to this new column Melissa wrote in message ... I've got 3 values: High, Medium, Low. How can I sort my table by all "High" items first, followed by "Medium" items, then by "Low" items? I can't use alphabetical sorting coz either ascending or descending order won't work. |
#3
|
|||
|
|||
Hi Melissa
Use a helper column. Assume your data is in Column A starting in Row 2. In row 2 in any unused column enter the fomula: =IF(A2="High",1,IF(A2="Medium",2,3)) Copy this down to the end of your data. Then select all data and sort by this new column ascending. The helper column can then be hidden. Hope this helps Rowan "Melissa" wrote: I've got 3 values: High, Medium, Low. How can I sort my table by all "High" items first, followed by "Medium" items, then by "Low" items? I can't use alphabetical sorting coz either ascending or descending order won't work. |
#4
|
|||
|
|||
Hi!
Use a helper column. Assume D1:D100 contains entries of either High, Medium or Low. In E1 enter this formula and copy down: =MATCH(D1,{"High","Medium","Low"},0) Then sort on column E ascending. Biff "Melissa" wrote in message ... I've got 3 values: High, Medium, Low. How can I sort my table by all "High" items first, followed by "Medium" items, then by "Low" items? I can't use alphabetical sorting coz either ascending or descending order won't work. |
#5
|
|||
|
|||
Personally, I'd cheat.
I edit|replace what: High with: 1High replace all then Medium with 2Medium and finally Low with 3Low do the sort and put the values back. But you could create a new custom list. Tools|Options|Custom Lists tab Type in: High, Medium, Low in the list entries box Click Add And back to try the sort. Melissa wrote: I've got 3 values: High, Medium, Low. How can I sort my table by all "High" items first, followed by "Medium" items, then by "Low" items? I can't use alphabetical sorting coz either ascending or descending order won't work. -- Dave Peterson |
#6
|
|||
|
|||
Melissa,
Make a custom list (Tools - Options - Custom Lists. Into the List entries box, type: High, Medium, Low separated by commas as shown. Click Add, OK). Now when you sort (Data - Sort), use the Options button, and open the First key sort order box, and select your list. -- Earl Kiosterud www.smokeylake.com "Melissa" wrote in message ... I've got 3 values: High, Medium, Low. How can I sort my table by all "High" items first, followed by "Medium" items, then by "Low" items? I can't use alphabetical sorting coz either ascending or descending order won't work. |
#7
|
|||
|
|||
Thanks Earl! That's exactly what I needed without having to create new
"helper" columns. "Earl Kiosterud" wrote: Melissa, Make a custom list (Tools - Options - Custom Lists. Into the List entries box, type: High, Medium, Low separated by commas as shown. Click Add, OK). Now when you sort (Data - Sort), use the Options button, and open the First key sort order box, and select your list. -- Earl Kiosterud www.smokeylake.com "Melissa" wrote in message ... I've got 3 values: High, Medium, Low. How can I sort my table by all "High" items first, followed by "Medium" items, then by "Low" items? I can't use alphabetical sorting coz either ascending or descending order won't work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to sort names in alphabetical order? | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
how do i sort excel worksheets by alphabetical order? | Excel Worksheet Functions | |||
how can I hide sort ascending and sort descending options in the . | Excel Discussion (Misc queries) |