From the course: Help Yourself: Tech Tips Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Excel: Finding duplicate values

Excel: Finding duplicate values

From the course: Help Yourself: Tech Tips Weekly

Start my 1-month free trial Buy for my team

Excel: Finding duplicate values

“

- [Instructor] Here in Excel, you'll see a long list of names and associated information. I have dealt with information like this, for example, when I send out letters or contact customers. To be efficient, not to mention to save money, it helps to locate the duplicates. One way to do so is to sort the list. This data is in a table, and it does have a header up here at row 1. The data is also consistent with all the columns containing the proper information. The sorting trick works only when the columns are consistent in this manner. Select a cell within the table. Press Control + Home to go to the first cell, A1, and ensure that you perform this step, as otherwise, Excel looks only at selected cells. From the Home tab, in the Editing group, choose Sort & Filter, Custom Sort. If the table has headers, as this one does, ensure that this box is checked, My data has headers. Choose the column to sort by. Because the…

Contents