The basics
Find the 2nd, 3rd or nth largest number
=LARGE(B2:B5,2)How it works in Excel
- B2:B5 is the list.
- 2 means the second largest.
- SMALL works the same way from the bottom.
- Repeated numbers each take a place.
The idea in general
It is like asking who came in second place.
What I assumed
- Your numbers are in B2:B5.
Check the result on your own data before relying on it.