UNIQUE

Function SUMIFS in Excel – Example

Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets

Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.

If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.

Discover how to remove duplicate values in Excel from one column or many columns from the ribbon or by formula