How to show top or bottom n results

Here we have some test scores for a group of students.

In column F, I want to set up a formula to display the top students by score.

LARGE returns the nth largest value in a data set.

Back in cell F5, I’ll enter the FILTER function.

Forarray, I want the full set of data.

We want to use greater than or equal to (>=), and LARGE with 3 fork.

When I enter the formula, FILTER returns the top three scores in a dynamic array.

If I temporarily change a score to 100, we’ll get a new list of top scores.

Now I can change H2 as I like, and FILTER will deliver correct results.

I’ll start by copying the formula in F5 to the clipboard.

Then I’ll paste the formula into cell J5, and replace LARGE with SMALL.

Finally, if I want the lowest score listed first, I need to changesort_orderto ascending.

When I enter the formula, we get the lowest 3 scores.