From the course: Excel 2016: Tips and Tricks

Unlock the full course today

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

Count the number of unique entries

Count the number of unique entries

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Count the number of unique entries

“

- [Voiceover] There are times when you ask yourself, "How many different entries appear in this range?" For example, in this worksheet called HR List, we see some Department names in column C. This list goes down to row 742. How many different departments do we have? I think for the other columns we probably wouldn't want to know that that much. If we looked at the Status column, for example, you could quickly see there are only four different entries there. But there certainly could be times when looking at different lists, you wanna know how many different entries are there? Now in a later movie, you might learn how to create a unique list. You might wanna do that with column C. But let's just count how we do this. I always wish there had been a formula, and maybe there will be some day, called Unique, and we could refer to a range and Excel would tell us how many different entries there are there. I'm going to insert a new row above row one. Simply right click row one, Insert. This…

Contents