How to find the Nth Largest in Excel

Both MIN and MAX in Excel will return the Minimum or Maximum value from a list. ¬†But what if you want to return a value that is the Nth largest in Excel? Or even the Nth smallest . How would you go about this type of ranking? You could use one of Excels Rank functions […]