| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Divide a list into Groups | Excel Discussion (Misc queries) | |||
| Want to divide a number into groups of thousands | Excel Discussion (Misc queries) | |||
| Divide by variable | Excel Discussion (Misc queries) | |||
| Numbers divide by 10 in any cell... | Excel Discussion (Misc queries) | |||
| divide a large group of people into smaller groups by their vote | Excel Discussion (Misc queries) | |||
Hybrid Mode
