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.