Tom’s Tutorials For Excel: Finding the Minimum and Maximum Numbers in a Filtered List
You can use the
SUBTOTAL function to look up the minimum or maximum number in a filtered list.
In the picture, the formula in cell B1 that returns Sue Flay’s minimum sales number is
The formula in cell B2 that returns Sue Flay’s maximum sales number is
The first argument for
Function_Num, basically what type of function you’re wanting to perform: