divide into group of 10

[alizok]

Hello everyone, I'm trying to automate my summary process what I’m looking is the formula that will look up the count in a specific group and divide it equally into 10 groups. For example let say I’m looking at group A that gives me count of 91 I need the formula to divide this number into 10 groups in the following manner:
1=9
2=8
3=8
4=8
5=8
6=8
7=8
9=8
10=8
Any ideas are welcom....

[shg]

That only adds up to 81.

You could do it like this:

Please Login or Register  to view this content.

[ChemistB]

Don't know where you're 91 comes from but you can substitute that in.

=INT(91/10)+IF(MOD(91,10)>=ROWS($A$1:A1),1,0) Dragged down
Does that work for you?

[alizok]

you are correct my mistake basicaly the table that i'm looking for in the end is as follow:

From To Decile
1 10 1
11 19 2
20 28 3
29 37 4
38 46 5
47 55 6
56 64 7
65 73 8
74 82 9
83 91 10

[alizok]

Don't know where you're 91 comes from but you can substitute that in.

=INT(91/10)+IF(MOD(91,10)>=ROWS($A$1:A1),1,0) Dragged down
Does that work for you?

You know this actually works the way I need it thank you very much for easy solution.

[ChemistB]

See attached spreadsheet. I used the formula I recommended in my first post.

[ChemistB]

Sorry, In B3 down, use this formula
=INT($E$1/10)+IF(MOD($E$1,10)>=ROWS($A$1:A2),1,0)+B2