Sorting Data in Excel Using the SORT Function

Sorting is the process of arranging data in a specific order to make it easier to analyse, understand trends, and identify patterns. In Microsoft Excel, sorting helps organize numbers, text, and dates efficiently. You can sort data in ascending order (smallest to largest) or descending order (largest to smallest).

Syntax: SORT(array, [sort_index], [sort_order])

Parameters:

• array: Data range to sort
• sort_index: Column or row to sort by
• sort_order:
  • 1 → Ascending
  • -1 → Descending

Why Sorting is Important

• Helps analyse trends quickly
• Makes large datasets easier to read
• Helps find highest, lowest, or specific values faster
• Improves overall data organization

Types of Sorting in Excel

1. Ascending Order

• Smallest to largest (Numbers:- 1:100)
• A to Z (Text)
• Oldest to Newest (Dates)

2. Descending Order

• Largest to smallest (Numbers:- 100: 1)
• Z to A (Text)
• Newest to Oldest (Dates)

Applying the SORT Function

Sort in Ascending Order

Steps:

1. Select the output cell (for example B1)
2. Enter the formula:

=SORT(A1:A8)

• Press Enter

Excel will automatically return the sorted list from smallest to largest.

Sort in Descending Order

Use the formula:

=SORT(A1:A8,1,-1)

Here:

• 1 → Sort by first column
• -1 → Descending order

Note: If your data changes frequently, using the SORT function is better than manual sorting because it updates results automatically.