Dynamic references aur scenario switching.
“CHOOSE, OFFSET, INDIRECT & Dynamic Ranges” is part of Level 2: Intermediate Excel — Lookups, Analytics & Pivot MIS (20 Lessons). Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.