Excel Forum
Similar Content
LARGE Function - Get the Highest Values from a List in Excel
Tutorial: Return the largest value from a list, or any of the top values, in Excel. This method use...
HLOOKUP in Excel
Tutorial: The Hlookup function allows you to scan a row from left to right in search of a value and ...
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
Macro: This free Excel macro filters a data set to display the bottom 10 percent of the data set ...

Excel Magic Trick 340: Weighted Percent without 2 Lowest (SMALL & LARGE functions)

Learn about the SMALL and LARGE functions and array syntax for retrieving more than one value. See how to calculate a grade that involves subtracting the two lowest scores, then calculating a weighted percentage.

Got a Question? Ask it Here in the Forum.