Divide variable numbers into groups

  • Thread starter Thread starter Marie Bayes
  • Start date Start date
M

Marie Bayes

I have a list of 20 numbers (all subject to changes) and I need to divide
these into 5 'ranked divisions'. ie, I need to give each number a 'division
number' from 1 to 5, ie, the highest 4 numbers would be division 1, the next
4 highest would be division 2 and so on up to 5. Does anyone know of a way
to do this?
 
This formula should do it...

=ROUNDUP(RANK(A1,$A$1:$A$20, -1)/4, 0)

With your list of 20 numbers in cells A1:A20 place this formula in B1 and
copy it down...
 
Works a treat - thanks v much
--
Marie Bayes


Jim Thomlinson said:
This formula should do it...

=ROUNDUP(RANK(A1,$A$1:$A$20, -1)/4, 0)

With your list of 20 numbers in cells A1:A20 place this formula in B1 and
copy it down...
Click to expand...
 
Back
Top