From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

Remove duplicates from a list vs. creating a new list without duplicates

Remove duplicates from a list vs. creating a new list without duplicates - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Remove duplicates from a list vs. creating a new list without duplicates

“

- [Instructor] In this worksheet, which has over 700 rows, 2 we can see pretty quickly there's some duplicates. 3 Rows 10 and 11 are duplicated. 4 And we also see that down rows 16 and 17. 5 And for many people, the first order of business is, 6 let's simply get rid of these. 7 There are a couple different ways to do this. 8 Now, equivalent to this, but actually a different approach, 9 is to say let's create a new list 10 that does not have the duplicates 11 and get rid of the old list. 12 So before we begin, let's make sure 13 that the list we're working with is contiguous. 14 We could convert this to a table, not truly necessary, 15 and there are some advantages there, 16 but if it's not a table, simply click on a cell, 17 press Control + A, 18 and then press Control + Period five or six times. 19 This will simply move the active cell 20 around the corners of the range. 21 So we can see this goes down to row 719…

Contents