filmov
tv
Extract a list of unique items out of an Excel list
Показать описание
00:00 Extract a unique listing from 2 lists (template with formula, no VBA)
00:18 Create a unique key to check for duplicates across multiple cells
00:51 Create a formula to determine which are duplicates
01:30 Extract the items that only appear once
Use a formula to extract the items that are unique based on a duplicate being across many cells in Excel
00:18 Create a unique key to check for duplicates across multiple cells
00:51 Create a formula to determine which are duplicates
01:30 Extract the items that only appear once
Use a formula to extract the items that are unique based on a duplicate being across many cells in Excel