Microsoft Excel - FILTER by Missing Data (plus, cool "sort by last name" trick)
Автор: BCTI
Загружено: 2026-01-11
Просмотров: 836
Описание:
Learn how to filter a source list of data to show what is missing from a secondary list (i.e., by what is missing). Also, see a super-cool sort trick to sort a list of single-cell full names by last name without splitting the full names into separate columns.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:36 File Download Instructions
00:45 Defining the Problem
01:34 Counting Occurrences of Attendees
01:55 Intelligent Range Selection with Dot-Operators
02:51 Inverting the Test Results
03:35 Filtering by the Test Results
04:48 Avoiding "Helper Column" Calculations
05:54 Sort Full Name by Last Name
09:28 All-In-1 Using the LET Function
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
