Extract a list of unique items out of an Excel list

preview_player
Показать описание
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
Рекомендации по теме