Rank in Ascending order

[#1]

Hi,

I have a straight table chart with a simple Rank function that goes like this: =Rank([Expression]). This works fine. It ranks Descending. How can I get it to rank Ascending?

Thanks

[#2]

Use the same expression in sort order.

[#3]

I think I should have explained better. What I have is expressions, ranking the previous expression. Example is

Expression 1 Expression 2

Rank([Expression 1])

4 2

6 1

3 3

2 4

Expression 2 is ranking in Descending order. I can't use the Sort Tab to achieve this because I have 8 expressions like 'Expression 1' and 8 expressions that rank these expressions. This is all in one table. Is there a way to rank in Descending in the expression?

[maneshkhottcpl · Accepted solution]

Hi,

Please refer the attached application. u can use the -(minus) sign in rank function.

[#5]

Thanks Manesh, does just what I wanted.