The value for N is supplied as the second argument.
In the example shown, “data” is the named range B5:B14.
In this example, the main challenge is to increment a value for nth.
However, rather than the “nth smallest” LARGE returns the “nth largest”.
from a set of numeric data.
Related videos
How to get nth values with SMALL and LARGE
