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
Extract items that appear only one time Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.
How to return many rows with VLOOKUP If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.
Remove Duplicate values in Excel Discover how to remove duplicate values in Excel from one column or many columns from the ribbon or by formula