Reverse Sort

Solved8.06K viewsFormulas and Functions
0
0 Comments

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.

Carl

16 Answers

1
quantrix qa3.18K 0 Comments

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!

-Mike

You are viewing 1 out of 16 answers, click here to view all answers.
1068 Questions total questions asked
86 Solved total solved questions
2656 Answers total answer posted
15283 Total users total community members