“How to Sort Excel Data Using the Sort Function in 3 Easy Steps!”

What is sort function?

The SORT function is delivered to sort data in a range in ascending or descending order. If you want to sort data, just activate sort function, select range & press enter button. Your result will be ready in a second. Values can be sorted by one or more columns. SORT provides a dynamic array of results.

What is the Syntax of Sort Function ?

Sort function syntax will deliver clear snapshot to understand it.

• array–Range or array to sort (Required)
• Sort_Index–Column index to use for sorting. Default is 1. (Optional)
• Sort_Order–Default is ascending order. (Optional)
  • 1 = Ascending and
  • -1 = Descending
• Sort_Col–Default is FALSE (Optional)
  TRUE = sort by column
  FALSE = sort by row

How it’s works?

Let’s see practical example how it’s works.

Example – 1 Beginner Example

In this example given a unsorted name list. It need to be sorted.

just activate sort function & select range B5: B13 finally press enter button.

Example – 2 Beginner Example – 2

Second example given a database-Name, age, join date & salary. It need to be sorted.

just activate sort function & select range B5: E13 finally press enter button.

Example – 3 “Sort_Index”

Now Let’s see a Novice level example “Sort_Index”. In this example you need to be sorted index wise.

just activate sort function & select range B5: E13, press comma button & type column number. It will delivered sorted data according to column number.

Example – 4 “Sort_Order”

Our forth example “Sort_Order”. How to extract sorted data in ascending or descending order ? Let’s see this, just activate sort function & select range B5: E13, press comma button & type column number as well as sorting order represent “1 = Ascending” & “-1 = Descending”. It will delivered sorted data according to “Sort_Order”.

Example – 5 How to Expands Sort Function Automatically

Our fifth example is How to Expands Sort Function Automatically? At first database need to convert into a table.

Now apply sort function & select range B5: E13 finally press enter button. Now we add any data in database, it will expand automatically.

Example – 6 Sort_Col

Finally we reach our last example i.e “Sort_Col”. just activate sort function & select range B5: G14, press comma, comma & comma button & select TRUE it will provide sort by column, It will delivered sorted data according to Sort_Col.

Download Link

If you required to learn more please visit our YouTube channel “FM SKILL SHARING“. Thank You