Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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
00:00 Introduction
01:19 Writing the formula
06:12 Inserting and deleting columns