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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.