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

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