Reverse Sort

Solved8.06K viewsFormulas and Functions

Ok, here is my problem.

I have a long list of inflation numbers, and I need to rank them. However, using the normal rank function, it assigns the best (1) value to the highest inflation area, and visa versa.

Is there a way to reverse this? Tks.



The RANK function has an optional third argument… either 0 or 1.

If order is 0 or omitted, value_list is ranked in descending order (e.g. 34, 10, 6, 2, 1). Otherwise, value_list is ranked in ascending order (e.g. 1, 2, 6, 10, 34).

Hope this helps!


You are viewing 1 out of 16 answers, click here to view all answers.