You might imagine that there is a function in Excel to tabulate the number of…unique entries within a range.…But there isn't, and I wish, well, there should be a function called Unique.…Still there is a way to get to this capability by way of an array formula.…And this is one of the stranger array formulas, and yet I don't mean strange in…the sense that you'll never use it. I think you might use it a lot.…I know I have and I remember when I first started using this, I did not…understand how it worked, but I knew that it worked.…And so, let's go down that same path and set up the situation where you need to know this.…

This set of data here has quite a few rows in the hundreds and you will see that…it's sorted by department.…Question just comes up, how many different departments do we have here?…In other words, how many unique entries do we see over there in column B?…Well, here's the formula and then we will backtrack and give you some…explanation of it, =sum and this will be an array formula, (1/(count if(.…

Resume Transcript Auto-Scroll

Author

Released

11/25/2009

In Excel 2007: Advanced Formulas and Functions, author and trainer 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 starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. He then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and even work with financial data using advanced formulas. Dennis focuses on practical examples that will help users easily transition to using these formulas and functions in real-world scenarios. Exercise files accompany this course.