Advanced Search
Formulas and Functions with Microsoft® Excel 2003
You can probably figure out that performing calculations on the smallest k values is similar. In fact, the only difference is that you substitute the SMALL() function for LARGE():
{=FUNCTION(SMALL(range, {1,2,3,...,k}))}
PREVIEW
Not a subscriber?
Start A Free Trial