How to Check Your Excel Spreadsheet for Duplicate Entries
Channel: Ann K. Emery
Date: 2014-02-02

How to check your Excel spreadsheet for duplicate entries using:
1) Pivot table tallies
2) Color-coding with conditional formatting

Follow along with the video:

00:00 Intro
00:14 Check Your Spreadsheet for Duplicate Entries
00:31 How to Check Larger Data Sets for Duplicates 
00:59 How to Use a Pivot Table to Check for Duplicates
01:24 How to Customize Your Pivot Table
02:42 How to Check for Duplicates Using Conditional Formatting
03:58 What to Do with Duplicates- Delete or Merge?
04:35 How to Remove Conditional Formatting

-----

Most "professional" reports are too long, dense, and jargony. Transform your reports with my course. You'll never look at reports the same way again. https://depictdatastudio.teachable.com/p/soar-beyond-the-dusty-shelf-report