Dynamic Arrays | FILTER | Retrieve Only Specified Columns

/in /by

The new FILTER function, as part of the new Dynamic Arrays in Excel, is fantastic. However, it is set to filter and retrieve data from contiguous datasets. This is a problem when, for example, a person needs 5 columns from a data-dump of 30 columns.

This video shows how to use the CHOOSE function to both, FILTER and retrieve specified columns–only those columns that you want.

Download the workbook: https://datascopic.net/FNA

 #DynamicArrays
#FILTER
#CHOOSE

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition