# Give ABC analysis with multiple duplicates

#### Maya Maile

##### New Member
Hello all,
I am really stuck with the following issue.
I have a table with multiple duplicate values. And I want to have ABC for the products with respect to the Annual Volume.
If there is a change in the Volume, for eg: No 997s Annual volume becomes 10000.
I want No 997 to automatically get sorted from largest to smallest(Go down). And I should get the ABC accordingly.
 No Annual Volume % Cummulative Rank ABC 464​ 56405​ 6%​ 6%​ 3​ A 464​ 56405​ 6%​ 11%​ 3​ A 464​ 56405​ 6%​ 17%​ 3​ A 464​ 56405​ 6%​ 22%​ 3​ A 463​ 37025​ 4%​ 26%​ 16​ A 997​ 32180​ 3%​ 29%​ 19​ A 474​ 54256​ 5%​ 34%​ 9​ A 474​ 54256​ 5%​ 39%​ 9​ A 474​ 54256​ 5%​ 45%​ 9​ A 474​ 54256​ 5%​ 50%​ 9​ A 474​ 54256​ 5%​ 55%​ 9​ A 689​ 51561​ 5%​ 60%​ 14​ A 689​ 51561​ 5%​ 66%​ 14​ A 641​ 78945​ 8%​ 73%​ 2​ A 45​ 98234​ 10%​ 83%​ 1​ B 465​ 54788​ 5%​ 88%​ 7​ B 465​ 54788​ 5%​ 94%​ 7​ C 927​ 32563​ 3%​ 97%​ 17​ C 927​ 32563​ 3%​ 100%​ 17​ C

#### Attachments

• Formula used-min.png
137.9 KB · Views: 9

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
I suggest to google for
Excel unique rank

Replies
3
Views
128
Replies
3
Views
216
Replies
4
Views
212
Replies
2
Views
160
Replies
3
Views
336

1,203,192
Messages
6,054,031
Members
444,696
Latest member
VASUCH

### 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