Divide variable numbers into groups

[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?

 

[Jim Thomlinson]

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...

 

[Marie Bayes]

Works a treat - thanks v much
--
Marie Bayes

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...