title: Divide excel column to N equal groups
body: <p>I have a column with ordinal values. I want to have another column that ranks them in equal groups (relatively to their value).</p>
  
  <p>Example: If I have a score and I want to divide to 5 equal groups:</p>
  
  <p>Score<br>
  100<br>
  90<br>
  80<br>
  70<br>
  60<br>
  50<br>
  40<br>
  30<br>
  20<br>
  10  </p>
  
  <p>What function do I use in the new column to get this eventually:</p>
  
  <p>Score   Group<br>
  100          5<br>
  90         5<br>
  80         4<br>
  70         4<br>
  60         3<br>
  50         3<br>
  40         2<br>
  30         2<br>
  20         1<br>
  10         1  </p>
  
  <p>Thanks! (I'm guessing the solution is somewhere in mod, row and count - but I couldn't find any good solution for this specific problem)</p>