Excel Forum

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.