Divide variable numbers into groups
 

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?


--
Marie Bayes

Divide variable numbers into groups
 

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

Jim Thomlinson


"Marie Bayes" wrote:

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?


--
Marie Bayes

Divide variable numbers into groups
 

Works a treat - thanks v much
--
Marie Bayes


"Jim Thomlinson" wrote:

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

Jim Thomlinson


"Marie Bayes" wrote:

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?


--
Marie Bayes