Sort other than by alphabetical ascending/ descending

[Guest]

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.

 

[R.VENKATARAMAN]

one pedestrian way is to have anoter column which designates high as
A,medium as B and low as C. you can use <if>function for this.
and then sort according to this new column

 

[Guest]

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

 

[Biff]

Hi!

Use a helper column.

Assume D1100 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

 

[Dave Peterson]

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.

 

[Earl Kiosterud]

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.

 

[Guest]

Thanks Earl! That's exactly what I needed without having to create new
"helper" columns.