Excel: UNIQUE function or Remove Duplicates [Dealing with Duplicate data]

Use the Remove duplicates feature in Excel or the UNIQUE function to find and remove duplicates. Both methods have their uses and depends on what your needs are. Bonus tip: Use named tables for dynamic updating 0:00 Itroduction 1:29 What not to do 2:45 What is a duplicate and what is it based on 3:58 Remove Duplicates feature 6:52 Using Remove duplicates to extract data 7:57 UNIQUE function and cell ranges to remove duplicates 9:33 Autoupdating with the UNIQUE function but not with Remove Duplicates feature 12:23 Using named Tables instead of ranges. Dynamic updating