Excel Forum
Similar Content
Sorting Data by Date, Text, or Number in Excel
Tutorial: Sorting Data can be done with a few quick clicks of the mouse. I have used the same data a...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Exce...
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...



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.