From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Remove duplicate records
From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365
Remove duplicate records
- [Instructor] In Excel, we have a way to filter the information for unique values and we have another tool we can use to remove the duplicate values. After watching this video, you'll know how to apply the advanced filter to filter unique records only, and how to use an advanced filter to remove duplicate records, and how to use that remove duplicates tool. Let's take a look at our removed duplicates workbook, and we'll start with the advance filter worksheet. I believe that we have duplicate order IDs in here, and to make it easy for us to see this before we filter the information, let's go ahead and select the data. I'll select the column headings and use control shift down arrow on my keyboard to select the range, and then on my home tab in the editing group we'll go to sort and filter, and filter. On the order ID, I'm going to have it sort from smallest to largest, and then scroll down and see if we see any…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Fill cells using Flash Fill2m 59s
-
(Locked)
Fill cells using advanced Fill Series options6m 44s
-
(Locked)
Create custom number formats8m 19s
-
Configure data validation9m 3s
-
(Locked)
Group and ungroup data and use subtotals and totals7m 10s
-
(Locked)
Remove duplicate records4m 24s
-
(Locked)
Create and manage custom conditional formatting rules9m
-
Create conditional formatting rules using formulas8m 8s
-
(Locked)
Challenge: Manage and format data30s
-
(Locked)
Solution: Manage and format data10m 35s
-
(Locked)
-
-
-
-