• 1
Abby

Excel Sort High Medium and Low

Question

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.

Share this post


Link to post
Share on other sites

2 answers to this question

  • 1

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.

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Who's Online   0 Members, 1 Anonymous, 20 Guests (See full list)

    There are no registered users currently online