Sequence - High to Low

[Yusuf]

Hi everyone

Is it possible to create a number sequence of Highest score to Lowest by summary values in a table.

In this case, I have several row headers in Pivot tables and I am unable to sort High to Low.

I would like to place a formula to the right of the last column of the pivot table and feature the best to worst by a number starting from 1 to 19.

Hopefully my example will show what I mean.
A1 = 43, A2 = 57, A3 = 29, A4 = 62

Result
A1, 3
A2, 2
A3, 4
A4, 1

Kind regards
Yusuf

 

[Yusuf]

Hi, is there anyone who might know if this is possible?

Thanks
Yusuf

 

[Ruddles]

I think you need to investigate the =RANK() function.

 

[Yusuf]

Excellent!

Thanks Ruddles