ChaplainLewis
New Member
- Joined
- Dec 11, 2015
- Messages
- 7
I have a list that ranges from 200-225 rows long and constantly in flux. In each row is a persons name, a score of sorts, and a grade. There's more than that but it doesn't really matter for this question. I might look something like this:
<tbody>
</tbody>
The real issue is the grade. Imagine if this table were several hundred rows deep. I am hoping to get the grade to populate based on the score as ordered into the overall list (something like a percentile, I think). The grading would be like this:
<tbody>
</tbody>
After sorting and adding the grade manually, it has gotten more than a little tedious. I'm hoping I can automate it. I've tried nested IF statements and messed around with the PERCENTILE.INC function (which was an interesting failure). I've even used RANK and a couple other functions I'm not terribly familiar with. I get close but can't seem to make it work. Any help would be appreciated.
Thanks a ton.
A | B | C | |
1 | Name | Score | Grade |
2 | Tom | 5.5 | |
3 | Sally | 3.2 | |
4 | Ed | 1.6 | |
5 | Alice | 4.9 | |
6 | Esther | 2.8 | |
7 | Jerry | 5.4 | |
8 | Lenny | 4.6 | |
9 | Delores | 1.6 | |
10 | Scott | 3.2 | |
11 | Craig | 3.7 |
<tbody>
</tbody>
The real issue is the grade. Imagine if this table were several hundred rows deep. I am hoping to get the grade to populate based on the score as ordered into the overall list (something like a percentile, I think). The grading would be like this:
A | B | |
1 | Grade | Percent |
2 | A | Top 10% |
3 | P | Next 24% |
4 | C | Next 33% |
5 | M | Bottom 33% |
<tbody>
</tbody>
After sorting and adding the grade manually, it has gotten more than a little tedious. I'm hoping I can automate it. I've tried nested IF statements and messed around with the PERCENTILE.INC function (which was an interesting failure). I've even used RANK and a couple other functions I'm not terribly familiar with. I get close but can't seem to make it work. Any help would be appreciated.
Thanks a ton.
Last edited: