HDTutorial
EN
How to Check Your Excel Spreadsheet for Duplicate Entries

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Check Your Excel Spreadsheet for Duplicate Entries

182,060 views October 25, 2014 5:16

Watch on YouTube
ChannelAnn K. Emery

Chapters

Description from the creator

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. depictdatastudio.teachable.com/p/soar-beyond-th…

About this tutorial

Ann K. Emery published this 5:16 video tutorial on October 25, 2014. It has been watched 182,060 times on YouTube.

Duration
5:16
Published
October 25, 2014
Views
182,060
Likes
741

Tags

Share

Further reading

  • Find and remove duplicates - Excel support.microsoft.com

    Sometimes duplicate data is useful, sometimes it just makes it harder to understand your data. Use conditional formatting to find and highlight duplicate data. That way you can review the duplicates and decide if you wa…

  • How To Find Duplicate Entries in Microsoft Excel groovypost.com

    When working with large Excel files, people tend to make mistakes and add duplicate entries in the worksheets. Here’s how to find duplicate entries in Excel spreadsheets the easy way.

  • 2 Simple and Easy Ways to Find Duplicates in Excel - wikiHow wikihow.com

    Now, choose how you'd like Excel to highlight the duplicates in your data, such as in Light Red Fill with Dark Red Text or with a Red Border. Click OK to see your highlighted duplicates. When you're finished, clear the…

This tutorial in other languages