Note there is no actual rank in the source data.
Instead, we are using the LARGE function to work directly with amounts.
In cell G5, LARGE returns 18,500, the “1st” largest value.
If this concept is new to you,here is a basic example.
you’re free to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
in a text string with the number format of your choice.
More than one condition can be tested by nesting IF functions.
