Look things up

List the top few rows

=TAKE(SORT(A2:B5,2,-1),3)

How it works in Excel

The idea in general

Line everyone up in order, then keep the front of the line.

What I assumed

Check the result on your own data before relying on it.

Related

Ask another question