login about faq

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.

asked Feb 21 '12 at 07:13

Abby's gravatar image

Abby
1966915


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

answered Feb 21 '12 at 11:06

Simon%20H's gravatar image

Simon H
5.0k62683

Thank you Simon how do you know all this stuff

(Feb 22 '12 at 15:25) Abby Abby's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:
    [text](http://url.com/ "title")
  • image:
    ![alt text](/path/img.jpg "title")
  • numbered list:
    1. Foo
    2. Bar
  • Code:
    • Within a paragraph:
      `code`
      surround code with grave accents (backticks)
    • Code snippet:
      Select the text and use the button on the icon of zeros and ones
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×3

Asked: Feb 21 '12 at 07:13

Seen: 2,069 times

Last updated: Feb 22 '12 at 15:25

groovyAnswers © 2007 - 2011 All Rights Reserved | Privacy | Contact