Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

You can remove duplicates in Excel in a few steps. Duplicates can create problems when you're dealing with data.

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

This option only appears if Excel detects data adjacent to the selected column. Uncheck all columns except the one containing the consolidated data and click "OK" to remove duplicates.

Microsoft Excel can do a lot of cool things. If you need it to generate random numbers, Susan Harkins can show you how.