I want column 4 to return the stars based on where the data falls in the table. I consider myself pretty good with excel but this one has me stumped. I though and if function couldn't figure that one out. Here is the Data
Thanks!
Was going to attach table but it says I cant... here is images.
<tbody>
</tbody>
Here is how the stars lies (in my spreadsheet I have pics of stars using wingdings symbol)
....................................................................................Total Nursing
<tbody>
</tbody>
Thanks!
Was going to attach table but it says I cant... here is images.
Facility | RNs | Total Nursing | Stars |
1 | .531 | 4.028 | |
2 | .335 | 3.606 | |
3 | .758 | 3.703 | |
4 | 1.255 | 6.075 | |
5 | .761 | 3.504 |
<tbody>
</tbody>
Here is how the stars lies (in my spreadsheet I have pics of stars using wingdings symbol)
....................................................................................Total Nursing
RN |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> | * | * | ** | ** | *** | |||||
<tbody> </tbody> | * | ** | *** | *** | *** | |||||
<tbody> </tbody> | ** | *** | *** | **** | **** | |||||
<tbody> </tbody> | ** | *** | **** | **** | **** | |||||
<tbody> </tbody> | *** | *** | **** | **** | ***** |
<tbody>
</tbody>