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.

How to use Excel’s UNIQUE Function Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

Microsoft Excel’s XLOOKUP() is powerful, but combined with wildcards, it’s also flexible.

With cell B2 selected, I can now use the fill handle in the bottom-right corner of the cell to duplicate this relative formula to the remaining rows of details.

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.