Sort by Sales (Highest First)

=SORT(A2:C5,3,-1)

📌 These formulas update automatically when new data is added.

⚠️ 9. Common Error – #SPILL!

You may see:

SPILL!

Causes

• Cells in the spill range already contain data

• Merged cells block the spill range

• Not enough space for results

Fix

✅ Clear the blocking cells.

✅ Avoid merged cells where dynamic arrays are used.

🎯 Mini Practice Project

Create: Employee_Report.xlsx

Data

Employee Department Salary

Rahul Sales 50000

Priya HR 60000

Amit Sales 55000

Neha Finance 65000

Karan HR 58000

Tasks

✅ Show only HR employees

=FILTER(A2:C6,B2:B6="HR")

✅ List unique departments

=UNIQUE(B2:B6)

✅ Sort employees by salary (highest first)

=SORT(A2:C6,3,-1)

✅ Generate employee serial numbers

=SEQUENCE(5)

✅ Generate five random performance scores (1–100)

=RANDARRAY(5,1,1,100,TRUE)

🏆 End of Part 11

After completing this lesson, you should be able to:

✅ Use FILTER() to create dynamic reports

✅ Sort data using SORT()

✅ Remove duplicates with UNIQUE()

✅ Generate number sequences using SEQUENCE()

✅ Create random sample data using RANDARRAY()

✅ Understand and resolve #SPILL! errors

📌 Dynamic Array functions simplify formulas, improve readability, and are highly valued in modern Excel workflows.

➡️ Double Tap ❤️ For Part-12