Divide variable numbers into groups

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

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

Marie Bayes

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top