There is a function in Excel called LARGE. It is a an odd name for what it does, but since I can’t think of anything better, maybe they couldn’t either!
=LARGE(array, K)
It requires two inputs. An array, normally a group of cells, and a number. What it returns is the “k-th largest value in a data set.” Which is a bit hard to understand, but is actually simple with an example. If the number is 1, then it will return the biggest number in the array. If the number is 2, then it will return the second biggest number from the array, etc.
So, you can use it to find the first, second, or third, or any other rank of number from a list.
We can see in the example above that 54 is the third largest value from the list.
Of course, if you put in a number that is the same as the number of numbers in your list, you will get the lowest number.
And, if your K value is bigger than how many numbers are in your list, you will get an error.
So, use LARGE next time you need to find which number is placed where.
If you just need the biggest values, so your K is one, then MAX might be a better choice.