How To: Return a sorted list based on row values in MS Excel

return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.

Using an array formula, return a descending sorted list of country names based on the values in a row. See how to use the functions INDEX, MATCH, RANK, COLUMN, COLUMNS in one array formula. See how to break ties using the RANK function by adding a small amount to each value. Also, see: Excel Magic Trick #52: RANK function 1st to 5t. Extract and Sort records with array formula.