We demonstrate how to remove duplicate entries in Excel. Specifically, this Excel tips and tricks tutorial shows you how to use the consolidate function to count how many times an entry exists. Then we show you how to remove duplicates and count how many times an entry exists using the Remove Duplicates function.

Also we show you how to turn your cells into a properly formatted table with filter and color options, as well as how to easily have Excel create graphs of your data.

If you are an Excel data analyst or an Excel beginner, this tutorial will quickly help you work your data and impress your boss.

0:00 Intro
0:44 How to Import a TXT into Excel
1:05 Count How Many Times an Entry Exists using the Consolidate Function in Excel
3:30 Remove Duplicates in Excel
4:35 Outro