From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions

Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Extract specific rows/columns from lists using new CHOOSEROWS and CHOOSECOLS functions

“

- [Instructor] Two new functions, choose rows and choose calls, meaning columns, will let us manipulate data in certain ways, and I think it's likely to be used as a way to create subordinate lists that are dependent upon a master list. Now the first one is actually a small example. I've got some data here, you can see it on the left-hand side of the screen, from columns A through M. I'd like to have a variation on that. I'd like to have an excerpt of that, perhaps on another worksheet. And I'll use the function called choose. As soon as you type it, you can see the choice down here, choose rows. I want to choose certain rows out of that list. Choose rows, double click and here's the data that we're looking at. Comma. And now we list the rows that we're interested in. I want to get the title from row one. So I'll put it in one, comma. And now I'm going to be using just the even numbered years. And it happens to be…

Contents