Dynamic Array Reporting Lab

Build a live management extract using FILTER, SORT, UNIQUE, TAKE and spill-aware formulas instead of manual copy-paste.

Advanced · 75–100 min

Objectives

Row	A: Employee	B: Branch	C: Month	D: Target	E: Collection	F: Status
2	Amit	Mumbai	Jan	50000	62000	Active
3	Priya	Pune	Jan	55000	49000	Active
4	Ravi	Nashik	Jan	45000	51000	Review
5	Neha	Mumbai	Feb	60000	58000	Active
6	Karan	Pune	Feb	52000	68000	Active
7	Meena	Nashik	Feb	48000	42000	Review
8	Amit	Mumbai	Mar	65000	72000	Active
9	Priya	Pune	Mar	60000	57000	Active

Create a unique branch selector
Use UNIQUE on the Branch column to create a live list of branches.
Build a spill-aware selector source.
Filter the active population
Use FILTER to return only rows whose Status is Active.
Create a live exception/report extract.
Sort by collection
Sort the filtered output by Collection descending.
Prioritize the strongest values without editing source rows.
Create a top-five management extract
Wrap the sorted result with TAKE to return the top 5 rows.
Build a compact management view.
Validate the spill result
Change one source value and confirm the dynamic extract updates without manual range edits.
Prove the report is refresh-friendly.
Explain the design
Write a short note explaining why the source remains untouched and how each dynamic function contributes.
Demonstrate professional reasoning.

Interactive practice runs in your browser.