Jump to content
groovyPost Forums

Excel Sort High Medium and Low


Recommended Posts

I have a an Excel table with a high medium and low column. I want to sort items into high medium and low but the table sorts the words alphabetically so i get all the highs then the lows with the mediums at the bottom of the list.

Is there a way to get excel to sort the column so the highs all come first followed by the mediums with the lows at the bottom of the list.

Link to post
Share on other sites

Click on any cell within the table

Click the” Data” Tab

In the “Sort & filter” group click “Sort”

This opens the sort dialog box

Click the arrow on the “sort by” box on the left and choose the column name that you want to sort

Click the arrow on the “Sort Order” box on the right and select “custom list”

Click in the “List entries” box and type High, Medium, Low

Click “Add”

This adds “High, Medium, Low” to the “Custom lists” box on the left

Select “High, Medium, Low” from the “Custom Lists” box

Click “Ok”

Click “OK”

Your column will now be automatically sorted High Medium Low

You can also use this technique to sort days of the week, months of the year or anything else you want.

Link to post
Share on other sites

Click on any cell within the table

Click the” Data” Tab

In the “Sort & filter” group click “Sort”

This opens the sort dialog box

Click the arrow on the “sort by” box on the left and choose the column name that you want to sort

Click the arrow on the “Sort Order” box on the right and select “custom list”

Click in the “List entries” box and type High, Medium, Low

Click “Add”

This adds “High, Medium, Low” to the “Custom lists” box on the left

Select “High, Medium, Low” from the “Custom Lists” box

Click “Ok”

Click “OK”

Your column will now be automatically sorted High Medium Low

You can also use this technique to sort days of the week, months of the year or anything else you want.

 

Thank you Simon how do you know all this stuff

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Similar Content

    • By Abby
      I have a protected worksheet but I want users to be able to sort one of the tables.
      When protecting the sheet I checked the options allowing users to select cells, sort and use auto filter but it won’t allow the table to be sorted without entering the password for the sheet. What am I doing wrong?
      Excel 2010
      Abby
  • Who's Online   0 Members, 0 Anonymous, 18 Guests (See full list)

    There are no registered users currently online

×
×
  • Create New...