Give ABC analysis with multiple duplicates

[Maya Maile]

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

 

[Sulprobil]

I suggest to google for
Excel unique rank