#### ezertuchev

##### New Member

- Joined
- Dec 11, 2016

- Messages
- 3

I have a column of scores assigned to different areas in my company, and I have to categorize them according to the following criteria:

- Top value (or values if tied) = "M"
- Top 50% = "AA"
- Top 70% = "A"
- Top 90% = "B"
- Remainder = "C"

The sum of all values is 250, so I've worked out the following:

- Top 50% = 125
- Top 70% = 50 (the next 20% of values)
- Top 90% = 50 (the next 20% of values)

So if my top values are 2 areas with 35 points each (70), the "AA" Areas would sum 125 points combined, the "A" Areas would sum the next 50 points combined and so on.

The problem is that I cannot work out a formula that helps me do this automatically (I have to sort the values and manually and select them to see how far down the list do I have to add up to get to the desired value, and so on.

I have to do this process for a whole lot of columns of data, so doing it manually would be extremely time-consuming.

I'm attaching a screen shot of some sample data that is representative of the data I have in my spreadsheet.

I'll appreaciate any help you can provide.

Eduardo Zertuche