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.
Just updated your iPhone to iOS 18? You'll find a ton of hot new features for some of your most-used Apple apps. Dive in and see for yourself:
Be the First to Comment
Share Your Thoughts