How to find the minimum and maximum values within a specified set of years in Excel Your email has been sent Image: iStock/Rawpixel Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft ...

Select any of the icon sets shown, and it will rank each of the cells based on how close it is to the minimum and maximum number in the data set. For the example below, I selected the star icon set.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.