=IF(J5>0.75,"5",IF(J5>0.6,"4",IF(J5>0.45,"3",IF(J5>0.3,"2",IF(J5>0.15,"1","0")))))
I have this formula but the data keeps changing making my scale irrelevant or not sensitive enough.
Instead of always changing the scale is there a way to rank J5 (1-5) comparing it to the rest of the data in the column.
For example look at the whole column, group into Quintiles and then assign a 1thru 5. This way it is always using its peers group to grade instead of an arbitrary scale?
I have this formula but the data keeps changing making my scale irrelevant or not sensitive enough.
Instead of always changing the scale is there a way to rank J5 (1-5) comparing it to the rest of the data in the column.
For example look at the whole column, group into Quintiles and then assign a 1thru 5. This way it is always using its peers group to grade instead of an arbitrary scale?