From the course: Excel 2016 for the Mac: Managing and Analyzing Data

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Advanced Filter to create unique lists

Advanced Filter to create unique lists - Microsoft Excel for Mac Tutorial

From the course: Excel 2016 for the Mac: Managing and Analyzing Data

Start my 1-month free trial

Advanced Filter to create unique lists

- [Male Narrator] Another capability of, Excels Advanced Filter feature, is it's ability to, create a unique list based on lists, that has duplicates in it. On this worksheet called, Uniquelists, in our Chapter Three file, you probably already have seen, rows five and six are a duplicate. There might be some others in here as well. We'd like to create a new list. We're not destroying this list. When we do this too, and unlike what you might have seen, in the two previous movies, we don't need, to use a criteria range here. Now, how many rows are in this list? One quick way to find out, wherever the active cell is, just double click its bottom edge, point to the bottom edge, double click. Go down to the bottom, 764 rows, and by the way, it looks like we've got another duplicate down there too, down this wall, right there, those two, and we saw another one up top, and there are probably some others, we don't know how many, and we're not concerned for the moment, about getting rid of…

Contents