Finding the Minimum and Maximum Numbers in a Filtered List - KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

## Thursday, January 23, 2020

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
`=SUBTOTAL(5,B5:B100)`
The formula in cell B2 that returns Sue Flay’s maximum sales number is
`=SUBTOTAL(4,B5:B100)`
The first argument for `SUBTOTAL` is `Function_Num`, basically what type of function you’re wanting to perform:
`1 AVERAGE2 COUNT3 COUNTA4 MAX5 MIN6 PRODUCT7 STDEV8 STDEVP9 SUM10 VAR11 VARP`
#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1