Filter Function in Excel Bonus:Xlookup

Filter function in Excel (XLOOKUP) with the Oddity of TRUE/FALSE and infusing XLOOKUP to dynamically select columns to be used for Filtering

Workbook link:
https://drive.google.com/file/d/1cq5rOLXBRUUfMGf94wzAGSjkPEM4R9Lx/view?usp=sharing

00:00 Introduction
00:49 Filter Function Intro
03:34 Filter function (OR Criteria)
06:20 Filter and return specific columns
09:17 Google sheets Example
10:19 Intro to last example
12:34 XLOOKUP -Dynamically select Column to Filter on
14:44 Selecting specific columns + last example

Тэги:

#filter_function_excel_xlookup #Excel #microsoft_Excel #XLOOKUP

Скачать видео