© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. I. KatzUp Up and Array!https://doi.org/10.1007/978-1-4842-8966-2_14

14. CHOOSECOLS and CHOOSEROWS: Less Is More

Abbott Ira Katz1  
(1)
Edgware, UK
 

Much of the time a dataset warehouses more information than you currently need. That’s why data are so often filtered, after all; and the decision to filter can cut back the data from one of two vantage points: you may need to filter the fields you need and shun the others, but at other times you may leave all the fields intact and apply the filter to selected records. Whichever route you take, the new CHOOSECOLS and CHOOSEROWS dynamic array functions will help point you in the right direction.

We’ve just learned ...

Get Up Up and Array!: Dynamic Array Formulas for Excel 365 and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.