Display unique items from large lists

- [Instructor] In this worksheet,…it's called HR List with Duplicates, we have duplicates.…We see them in rows four and five, also in rows 12 and 13.…And there are probably a few others, as well.…Now, sometimes the objective here is simply…get rid of the duplicates.…We can do that directly…with a feature on the Data tab called Remove Duplicates.…At other times, the objective might be…let's not destroy this list,…but let's create another list that has unique entries in it.…We can do that by way of what's called an Advanced Filter.…

Then we're going to shift the focus to the idea…that sometimes we're looking at a single column only.…Column C has lots of repeat entries here.…Let's create a new list of unique entries from column C,…in other words, each department will appear once.…And there are two different ways we can approach that.…Let's first deal with the issue of simply…getting rid of the duplicates.…Dragging across the data here,…in this case columns A through K,…or we could have clicked within the data, press Ctrl + A,…