Microsoft Excel is perhaps the most powerful spreadsheet application you can buy. But it also has some simple functions, like finding duplicates in data.

Excel provides built-in tools to help you to find discrepancies like Filters, Conditional Formatting, advanced functions (If and IS, VLookUp, etc.), and Add-ins.

How to exclude high and low in an average in Excel It’s common to eliminate the highest and lowest values, or outliers, when averaging. Teachers and statisticians do so frequently.

Filters are great tools, but you can't remove specific items from the results. When you need to do this, try Find All in Excel instead.