In this worksheet called Unique…imagine if we were trying to come up with a list of…departments, a unique list.…There are a couple of different ways to do that.…We're not actually going to do that just yet…in this particular movie,…but we could for example create a pivot table,…and using a department field…we'd have a unique list of all of our departments.…Another way to do this is to select column B,…and if we're still using a feature on the data tab…called Advanced Filter.…But let's say what we really need is just a count…of how many different entries there are.…We possibly might want to do this for other columns as well.…

There's 687 rows in this list.…I've simply put in the COUNTA formula here,…to count the number of entries…for example in column G.…So let's put a new row above this.…This isn't necessarily the best place…to share this information,…but I'm going to right click Row 1 and insert.…The formula you're about to see looks really unusual.…It's a little bit tricky to describe,…but nevertheless let's point out…

Resume Transcript Auto-Scroll

Author

Released

12/10/2014

Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.