Join Curt Frye for an in-depth discussion in this video Removing duplicate values, part of Excel 2013: Shortcuts.
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.…As my sample file I will use Duplicates, which you can find in the Chapter 6…folder of your Exercise Files archive.…
This file contains a simple data list. One of those names, Steven Ng, occurs twice,…and you'll notice that there are two individuals named Curt.…Let's say that I want to remove duplicate values in this list.…To do that I just click any cell in the list, as I have already done, and then…on the Data tab, click Remove Duplicates.…In the Remove Duplicates dialog box, I can identify the columns that need to…match for a duplicate to be identified and removed.…So you can see that Excel properly identified the entire list. It has also…
Author
Released
2/28/2013- Entering a data series using the fill handle
- Creating hyperlinks
- Setting a print area
- Applying a table style
- Creating substitute data sets using scenarios
- Wrapping and shrinking text
- Creating a data entry form
- Removing duplicate values
- Inserting the current date or time
- Generating a list of unique random numbers
- Calculating running totals
- Analyzing a formula for errors
- Summarizing data with charts and PivotTables
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Appropriate for all -
Office 2013 New Features
with David Rivers2h 31m Appropriate for all -
Cleaning Up Your Excel 2010 Data
with Dennis Taylor1h 27m Appropriate for all
-
Introduction
-
Welcome55s
-
-
1. Top Ten Shortcuts
-
Super-hiding worksheets3m 39s
-
2. Controlling the Excel Program and Interface
-
Customizing the Ribbon4m 57s
-
3. Managing Workbooks and Worksheets
-
Setting a print area2m 32s
-
Zooming in or out quickly2m 48s
-
4. Organizing Data
-
Creating a custom view4m 16s
-
Finding a target value3m 24s
-
-
5. Entering and Formatting Data
-
Picking data from a list1m 40s
-
Creating a data entry form3m 25s
-
6. Managing a Data Series
-
Extending a date series3m 47s
-
Removing duplicate values3m 34s
-
-
7. Working with Dates and Times
-
8. Creating Useful Formulas
-
Rounding values6m 30s
-
9. Managing Formulas
-
Calculating running totals1m 55s
-
Commenting within a formula2m 28s
-
Watching a cell's value3m 16s
-
-
10. Summarizing Data Using Charts and PivotTables
-
Creating recommended charts1m 37s
-
Delaying PivotTable updates2m 28s
-
Conclusion
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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