Mark Coppock/Digital Trends Using the Remove Duplicates function You can also elect to have Excel remove any duplicate data from your spreadsheet.

How to remove duplicates in Excel for a single column When you have duplicate data that you want to remove from a single column in your dataset, start by clicking into the column you want to dedupe.

If your source data is in Excel and has duplicates, run Power Query to remove those duplicates before running a Word mail merge.

When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

DGET has only three arguments, making it much more straightforward to use than other Excel lookup functions. The DGET function is an old-school tool!