Excel FILTER: Non-Adjacent Columns Dynamic Array Formula

Excel FILTER: Non-Adjacent Columns Dynamic Array Formula

Computergaga

54 года назад

6,381 Просмотров

In this video, we return non-adjacent columns with FILTER. This video shows three different examples to return non-adjacent columns from arrays.

Advanced Excel Formulas book - https://amzn.to/3Rg87Go

Dynamic array functions such as FILTER and SORT can only return consecutive columns natively. However, there are various methods to specify the columns to return from the array. Functions such as CHOOSECOLS, CHOOSE and INDEX are wonderful for these tasks.

Timings in the video.
00:00 - Return non-adjacent columns with FILTER
01:24 - CHOOSECOLS to specify columns in array
02:54 - CHOOSE for absolute column references
04:00 - SEQUENCE to prevent column index numbers
04:58 - Dynamic column references from array
07:09 - INDEX & MATCH for dynamic non-adjacent columns

Find more great free tutorials at;
https://computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Тэги:

#non-adjacent_columns_with_filter #filter_function #excel_filter_function #dynamic_array_formulas_in_excel #dynamic_arrays #filter_function_in_excel #excel_filter_non_adjacent_columns #excel_dynamic_arrays #choose_function #dynamic_array_formulas #index_function_in_excel #choose_function_in_excel #filter_formula_in_excel #excel_hacks_and_tricks #excel_hacks_for_data_analysis #excel_array_formulas #excel_hacks #excel_filter_hack #excel_filter_different_columns
Ссылки и html тэги не поддерживаются


Комментарии: