Excel FILTER Function to Return Non-Adjacent Columns in Any Order

In this video, you’ll learn how to filter non-adjacent columns in any order. You can return any number of columns that are not in the original order with the FILTER function in Excel. I also explain how to make the formula dynamic to prevent errors when inserting and deleting columns.
If you’d like to read the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/functions/filter-non-adjacent-columns

Related Videos:

Dynamic Array Functions & Formulas that Spill: https://www.youtube.com/watch?v=1HF0UGMF070&t=50s

Dynamic Drop-down Lists: https://www.youtube.com/watch?v=Dt5ZRL5mXhk

UNIQUE & FILTER Functions: https://www.youtube.com/watch?v=ftDXUOKCaUM

#MsExcel #ExcelCampus

Видео Excel FILTER Function to Return Non-Adjacent Columns in Any Order канала Excel Campus - Jon