Join Dennis Taylor for an in-depth discussion in this video Identify data that's been duplicated using a specialized array formula, part of Excel 2011 for the Mac: Managing and Analyzing Data.
- In this workbook, we're looking at a worksheet…called "Identifying Duplicates."…In an earlier movie, you might have seen…how to remove duplicates from a worksheet.…On the other hand, sometimes it's just as important…to identify which records within a list…have been duplicated.…For example, in rows 4 and 5,…we do see…the information on Juan Bishop has been duplicated.…In this situation, we must make sure…that the duplicates are together.…Usually, they will come together simply by sorting.…Let's show two different ways to identify these duplicates.…
In both cases, we'll begin by inserting…a new column to the left of column A.…Simply right-click column A and Insert.…I'll zoom in a bit…using control shift and the mouse wheel.…You can also this with control shift…and two fingers on a trackpad…or control shift and a single finger on a magic mouse.…All right, we're going to write a formula here…comparing,…for example,…the data in rows two and three,…and then we'll copy it down the column.…And we can use the countif function.…
- Multiple-key sorting
- Sorting columns left-to-right
- Filtering columns
- Creating a top-ten list with values or percentages
- Using Advanced Filter for complex filters
- Setting up subtotals
- Using the Remove Duplicates command
- Using SUMIF, COUNTIF, and related functions
- Working with the database functions, such as DSUM and DMAX
Skill Level Intermediate
Financial Literacy: Reading Financial Reportswith Rudolph Rosenberg1h 25m Appropriate for all
Excel for Mac 2011 Essential Trainingwith Curt Frye6h 32m Beginner
1. Sorting Data
2. Filtering Data
3. Advanced Filter
4. Creating Automatic Subtotals in Sorted Lists
5. Eliminating Duplicate Data
6. Data Analysis Tools
- 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.Cancel
Take 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.