Channel: Excel Campus - Jon

Category: Education

Tags: excel filter different columnsexcel tips and tricksexcel dynamic filterexcel for analystsexcel unique different columnsfilterexcel filter hackexcel hacksexcel filter non adjacent columnsadvanced filter examplesexcel filter functionexcel dynamic arrays beginner to expertexcel campusexcel 365excel dynamic arraysexcel functions that return rangesexcel unique functionadvanced filter or criteriaexcel in any order

Description: 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: excelcampus.com/functions/filter-non-adjacent-columns Related Videos: Dynamic Array Functions & Formulas that Spill: youtube.com/watch?v=1HF0UGMF070&t=50s Dynamic Drop-down Lists: youtube.com/watch?v=Dt5ZRL5mXhk UNIQUE & FILTER Functions: youtube.com/watch?v=ftDXUOKCaUM #MsExcel #ExcelCampus