# How can I calculate sales quintiles?

#### shuksan

##### New Member
I have a list of 2000 product skus with sales volume from last year. I would like to break the skus into 5 equal groups, quintiles, with each group having 1/5th of the total sales volume. I'd like a formula that would insert "q1" or "q2", etc, so that I can sort on the quintiles and summarize them. Clearly, 20% of my skus generate 80% of my sales, and I would like to focus on them more!

I can do this manually with data sorting highest to lowest, calculating a % of total sales, adding up the cumulative sales %, and then labeling the quintiles, but I am looking for a automatic way to do this, as I want to review other data for each sku as well, such as inventory levels, gross margin, etc, and rank those items as well.

any ideas? sounds simple to me, but I've tried several things that dont' seem to work, including percentile, rank, large, etc...

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Replies
1
Views
669
Replies
9
Views
740
Replies
4
Views
279
Replies
25
Views
803
Replies
6
Views
199

1,221,127
Messages
6,158,099
Members
451,464
Latest member
Holden3

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

### Which adblocker are you using?

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

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