Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
In this video, you’ll learn how to filter nonadjacent 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...
Related Videos:
Dynamic Array Functions & Formulas that Spill: • Dynamic Array Functions Are The Best ...
Dynamic Dropdown Lists: • Dynamic Dropdown Lists Dashboard Par...
UNIQUE & FILTER Functions: • UNIQUE & FILTER Functions Dashboard P...
#MsExcel #ExcelCampus
00:00 Introduction
01:19 Writing the formula
06:12 Inserting and deleting columns