Automatic deletion of duplicates in Excel with NO VBA

Опубликовано: 28 Сентябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting

151

00:00 Create a unique listing template (no VBA- just paste the list and duplicates get removed)
00:15 Setup the template
00:22 Identify duplicates across multiple columns
00:55 Determine which duplicate instance it is (1st unique value, 2nd is duplicate etc)
01:34 Create a unique lookup number for each item you want to keep (not the duplicates)
02:21 Setup the template that will remove the duplicates with formula
03:45 How this works to ignore the duplicates

Create a formula based template (no VBA) to automatically remove the duplicate items from a list, even if the duplicates are across multiple columns.