Sorting (single and multi-column) in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants you to organize the sales data to easily see the best performing products by region and sales amount.

📊 Data: You have a table with columns: Region, Product, Sales Amount, and Date of Sale. The data includes multiple sales records from different regions and products.

🎯 Deliverable: Create a sorted table first by Region alphabetically, then by Sales Amount from highest to lowest within each region.

Sample Data

Region	Product	Sales Amount	Date of Sale
East	Shirt	250	2024-05-01
West	Hat	150	2024-05-03
East	Shoes	300	2024-05-02
North	Shirt	200	2024-05-01
South	Hat	180	2024-05-04
West	Shoes	400	2024-05-05
North	Hat	220	2024-05-03
South	Shoes	350	2024-05-02

1

Step 1: Select the entire data table including headers.

No formula needed; just select cells A1:D9.

Expected Result

The full data table is selected.

2

Step 2: Sort the data by Region alphabetically (A to Z).

Use Data > Sort range > Sort by 'Region' A -> Z.

Expected Result

Rows are rearranged so that regions appear in alphabetical order: East, North, South, West.

3

Step 3: Add a second sorting level by Sales Amount from largest to smallest within each Region.

In the Sort range dialog, add 'Sales Amount' and sort Z -> A.

Expected Result

Within each Region group, rows are sorted so that the highest sales amount is first.

4

Step 4: Verify the sorted data to confirm Region is alphabetical and Sales Amount is descending within each Region.

No formula; visually check the sorted table.

Expected Result

Data shows East region rows first with sales sorted high to low, then North, South, and West similarly sorted.

5

Step 5: Alternatively, create a new sorted table using the SORT function with multiple columns.

=SORT(A2:D9, 1, TRUE, 3, FALSE)

Expected Result

A new table appears sorted by Region ascending and Sales Amount descending.

Final Result

Region  | Product | Sales Amount | Date of Sale
---------------------------------------------
East    | Shoes   | 300          | 2024-05-02
East    | Shirt   | 250          | 2024-05-01
North   | Hat     | 220          | 2024-05-03
North   | Shirt   | 200          | 2024-05-01
South   | Shoes   | 350          | 2024-05-02
South   | Hat     | 180          | 2024-05-04
West    | Shoes   | 400          | 2024-05-05
West    | Hat     | 150          | 2024-05-03

✓Data is organized by Region alphabetically: East, North, South, West.

✓Within each Region, sales records are sorted from highest to lowest sales amount.

✓This sorting helps quickly identify top-selling products per region.

Bonus Challenge

Create a dynamic sorted table that updates automatically when new sales data is added.

Show Hint

Use the SORT function combined with ARRAYFORMULA or dynamic ranges like A2:D to include new rows automatically.