# dividing rows in excel

#### dheeraj27

##### New Member
i want to divide work between my team for example there are 5 member and there to 20 task, so each person can do 4 task, so i want to in assigned to coloum it mention in first 4 row name one person from 4to 8 other and goes on....

any idea hw can i do it...

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
i want to divide work between my team for example there are 5 member and there to 20 task, so each person can do 4 task, so i want to in assigned to coloum it mention in first 4 row name one person from 4to 8 other and goes on....

any idea hw can i do it...
Excel Workbook
ABCDEF
11AA4
22AB
33AC
55BE
66B
77B
88B
99C
1010C
1111C
1212C
1313D
1414D
1515D
1616D
1717E
1818E
1919E
2020E
Sheet1

it work greatly thanks man

hi,

i needed a change in this formula... task should be divide like.. a,b,c,d,e,a,b,c,d,e,a... like this ... nt by aaaabbbbcccccdddd.....

Try:
=INDEX(\$E\$1:\$E\$5,IF(MOD(ROW(),5)=0,5,MOD(ROW(),5)))

it is working... but there is one thing... in previos formula, i can change the no. of person.. but if i change reduce the no of person from 5 in this formula.. is give 0 ... so if it is possible can u make like that...

but really thannks for ur hardwork....

it is working... but there is one thing... in previos formula, i can change the no. of person.. but if i change reduce the no of person from 5 in this formula.. is give 0 ... so if it is possible can u make like that...

but really thannks for ur hardwork....

Excel 2010
ABCDE
11AA
22BB
33CC
44A
55B
66C
77A
88B
99C
1010A
1111B
1212C
1313A
1414B
1515C
1616A
1717B
1818C
1919A
2020B
Sheet1
Cell Formulas
RangeFormula
B1=INDEX(\$E\$1:\$E\$5,IF(MOD(ROW(),COUNTA(\$E\$1:\$E\$5))=0,COUNTA(\$E\$1:\$E\$5),MOD(ROW(),COUNTA(\$E\$1:\$E\$5))))

its working....Thanks...

You are welcome

Replies
2
Views
116
Replies
6
Views
604
Replies
1
Views
208
Replies
7
Views
402
Replies
5
Views
364

1,196,371
Messages
6,014,893
Members
441,854
Latest member
Amstaff

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back