From the course: Advanced Excel for Financial Planning and Analysis (FP&A)

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

CHOOSECOLS and CHOOSEROWS for reporting and analysis

CHOOSECOLS and CHOOSEROWS for reporting and analysis - Microsoft Excel Tutorial

From the course: Advanced Excel for Financial Planning and Analysis (FP&A)

Start my 1-month free trial Buy for my team

CHOOSECOLS and CHOOSEROWS for reporting and analysis

“

- In Excel and FP&A, we often need to extract multiple rows or columns of data. Sometimes they're next to each other, but sometimes they're not. Well, what if you could extract exactly the rows and the columns you need no matter where they're located, without filtering, without slicing, without using pivot tables and without messy manual captures? CHOOSECOLS and CHOOSEROWS lets you surgically pull specific parts of your data. You can do it by period, you can do it by salesperson, by business unit, department, by scenario, whatever you want to do, and then you can drop them right where you need them to be. Let's take a look at an example. Here on the summary worksheet, you can see that I have salespeople and dates. This is a dynamic array coming from the financial summary dynamic total right here. We also have the dates coming from a dynamic array at C8 on the same page, it's all of these dates, but you're going to note that this is a horizontal array and I want this one to be…

Contents