SUMIFS Function in Excel
Discover how to use the SUMIFS function in Excel to filter and sum data based on multiple criteria in your worksheets
UNIQUE function
UNIQUE Function – Remove duplicates with formulas
UNIQUE is a new Excel function to remove automatically the duplicates in a list of data. It's amazing how simple is it to use this function
How to find duplicate values in Excel?
You can easily find all your duplicate values in a column with a simple formula and 2 Excel functions; FILTER and COUNTIF