Create remove duplicates template that is automatic (no VBA)
Опубликовано: 04 Октябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
206
2
00:00 Create a remove duplicates template (with no VBA)
00:30 Create helper columns
00:45 Identify the duplicates across multiple rows
01:05 Identify which instance of the duplicate is in each row (1st time or nth time) (NB MOST IMPORTANT STEP)
02:17 Create a helper column which number each unique item uniquely (NB MOST IMPORTANT STEP)
03:14 Create the remove duplicities template area
03:24 Create the lookup to each unique value
05:00 The reason this works (it ignores the duplicates)
