henningstl
New Member
- Joined
- Oct 29, 2018
- Messages
- 1
Hi,
I'm currently working on a worksheet and need to find a way to classify the following:
Below is a snapshot of some rankings by state for a measure I'm looking at. What I need to do is classify them on a Red (Top 25%)/Orange/Yellow/Green (Lowest 25%) scale. The problem I'm having though is that each state doesn't have the same number of health plans.
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
Is there an easy formula I can use to get these classified into the appropriate buckets? Any assistance would be greatly appreciated.
I'm currently working on a worksheet and need to find a way to classify the following:
Below is a snapshot of some rankings by state for a measure I'm looking at. What I need to do is classify them on a Red (Top 25%)/Orange/Yellow/Green (Lowest 25%) scale. The problem I'm having though is that each state doesn't have the same number of health plans.
| State | Rank |
| AZ | 1 |
| AZ | 1 |
| FL | 6 |
| FL | 9 |
| FL | 11 |
| FL | 12 |
| FL | 10 |
| FL | 1 |
| FL | 3 |
| FL | 7 |
| FL | 8 |
| FL | 4 |
| FL | 5 |
| FL | 2 |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
Is there an easy formula I can use to get these classified into the appropriate buckets? Any assistance would be greatly appreciated.
