Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Melissa
 
Posts: n/a
Default 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   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

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   Report Post  
Rowan
 
Posts: n/a
Default

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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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   Report Post  
Melissa
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to sort names in alphabetical order? Fredrik Jonsson Excel Discussion (Misc queries) 0 September 1st 05 04:33 PM
Sort Ascending button - Excel 2003 Ann Scharpf Excel Discussion (Misc queries) 0 May 23rd 05 11:11 PM
Sort Ascending button - Excel 2003 bigwheel Excel Discussion (Misc queries) 1 May 23rd 05 11:10 PM
how do i sort excel worksheets by alphabetical order? Birichica Excel Worksheet Functions 4 February 23rd 05 06:10 PM
how can I hide sort ascending and sort descending options in the . vida Excel Discussion (Misc queries) 0 December 11th 04 01:31 AM


All times are GMT +1. The time now is 10:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"