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 - Microsoft Excel for Mac Tutorial
From the course: Excel 2016 for the Mac: Managing and Analyzing Data
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…
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.