As your company grows, you've probably found that one of the most common problems in maintaining good data hygiene is identifying and eliminating duplicate values from a data list. In this movie I will show you how to quickly and easily remove duplicate values from a data list, but also give you some warnings about how it can affect your data and why you should never remove duplicates on your only copy of a data list.
- [Voiceover] As your company grows you have probably…found that one of the most common problems in…maintaining your data hygiene is identifying…and eliminating duplicate values from a data list.…In this movie, I will show you how-to quickly…and easily remove duplicate values from a list.…But also give you some warnings about how it can…affect your data, and why you should never remove…duplicates from your only copy of a data list.…For this example, I have a list of six names…and they are here in cells B3 through C8.…
And what I'd like to do, first, is remove…duplicates based on the values in one column.…So, for example, if I only wanted to have…a single entry for a given last name…I would select cells C3 through C8.…So I'll go ahead and do that, selecting C3 to C8.…And then on the data tab of the menu…click remove duplicates.…Doing so displays the remove duplicates dialog box…and I see that I have two duplicates found…and that four unique values will remain.…
So I have Frye and Frye and Ng and Ng.…I'll go ahead and click remove duplicates…
Author
Curt Frye
Released
5/18/2016- Entering a data series using the fill handle
- Creating hyperlinks
- Controlling the Ribbon
- Moving between worksheets quickly
- Setting a print area
- Selecting noncontiguous cells
- Applying a table style
- Creating substitute data sets using scenarios
- Wrapping and shrinking cell text
- Entering data quickly
- Removing duplicate values
- Inserting the current date or time
- Generating a list of unique random numbers
- Calculating running totals
- Summarizing data
- Dealing with formula errors
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome56s
-
-
1. Top 10 Shortcuts
-
Hiding worksheets1m 33s
-
2. Controlling the Excel Program and Interface
-
Controlling the Ribbon1m 33s
-
-
3. Managing Workbooks and Worksheets
-
Setting a print area1m 56s
-
4. Organizing Data
-
Creating a custom view2m 36s
-
Finding a target value3m 8s
-
5. Entering and Formatting Data
-
Picking data from a list1m 19s
-
6. Managing a Data Series
-
Extending a date series3m 10s
-
Removing duplicate values3m 51s
-
-
7. Working with Dates and Times
-
8. Creating Useful Formulas
-
Rounding values5m 23s
-
9. Managing Formulas
-
Calculating running totals2m 26s
-
Commenting within a formula3m 13s
-
Dealing with errors4m 8s
-
-
Conclusion
-
Next steps1m
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Removing duplicate values