Excel Forum



Excel Magic Trick 163 Formula Return Descending Sorted List


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.





Got a Question? Ask it Here in the Forum.