# Actual Top 10

#### krishna334

##### Active Member
Hi All,

In my worksheet

Column A : Qty Change
Column B : Rank of Qty Change using RANK function
Column C : Ranking which I need.

How can I get the rank in column C?

Is it possible by using any formula?

Last edited:

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### scopar

##### New Member
Hi,

I found a similar question that had an answer. I'm not sure of the correct way to link to the other thread, but here is the formula that seems to do what you're asking:

Code:
`` =SUM(--ISNUMBER(MATCH(ROW(INDIRECT("1:"&RANK(A2,A\$2:A\$13))),RANK(A\$2:A\$13,A\$2:A\$13),0)))``

It must be confirmed with CTRL + SHIFT + ENTER instead of just ENTER

I can't take much credit for this (if it works for you) as I just happened to be looking for something similar and found this answer.

Here's the link to the thread that I found: RANK - Non unique values, contiguous rank required

Post #4 is the one that gives this solution.

Hope this works for you.

Regards,
Scott

#### krishna334

##### Active Member
Thank you Scott....perfect Formula...its working

Replies
5
Views
552
Replies
15
Views
442
Replies
4
Views
401
Replies
0
Views
556
Replies
0
Views
245

1,191,381
Messages
5,986,300
Members
440,017
Latest member
vasanrajeswaran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back