I want to rank data in reverse formate

[sourabh24u]

I want if someone get rank 1 his block is grater than rank 2
here we can see BB is on rank 4 but his block is bigger than rank 1

I want this data in reverse order like BB is smallest one and AA is biggest one
please refer the attachment
kindly solve with screenshot
it could be ore helpful for me

[kersplash]

You've asked the same question here;
https://www.excelforum.com/excel-gen...e-formate.html
Maybe clarify which method of the three provided "isn't working" for you.

[shukla.ankur281190]

May be change the rank function.

Try
G4

Please Login or Register  to view this content.

Drag down!

[sourabh24u]

actually the last one is worked but i am not appling on my data so i asked for screenshot

[sourabh24u]

its not working because i dont want to reverse the data
i need to reverse only chart blocks

[shukla.ankur281190]

You can hide the column as helper column if you wish

[alansidman]

Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.

Thread Closed.