please help me on function or macro

[mgm90210M]

a1	b1	c1	d1	e1
1	reading glasses <colgroup><col></colgroup><tbody> </tbody>
2	bifocal reading glasses <colgroup><col></colgroup><tbody> </tbody>
3	bifocal reading glasses <colgroup><col></colgroup><tbody> </tbody>
4	foster grant reading glasses <colgroup><col></colgroup><tbody> </tbody>
5	foster grant reading glasses <colgroup><col></colgroup><tbody> </tbody>
6	designer reading glasses <colgroup><col></colgroup><tbody> </tbody>
7	designer reading glasses <colgroup><col></colgroup><tbody> </tbody>
8	designer reading glasses <colgroup><col></colgroup><tbody> </tbody>
9	designer reading glasses <colgroup><col></colgroup><tbody> </tbody>
10	designer reading glasses <colgroup><col></colgroup><tbody> </tbody>
11	designer reading glasses <colgroup><col></colgroup><tbody> </tbody>
12	designer reading glasses <colgroup><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

i have 2000 row like this
please i need to divid all of 12 row from a3:a14 to 12 group
i need solution to write automatic in "c" colum from c3:c14
the number of the group

ia am mean from c3 and c4 and in c5 and in c6 to write "grope 1"
and c7 and in c8 and in c9 and in c10 "group 3"
and in c11 and in c12 and in c13 and in c14 write "group 3"
automatic with function or macro



please help me

 

[FormR]

Like this maybe?

Excel Workbook
	A	B	C
1	1	reading glasses	Group 1
2	2	bifocal reading glasses	Group 1
3	3	bifocal reading glasses	Group 1
4	4	foster grant reading glasses	Group 1
5	5	foster grant reading glasses	Group 2
6	6	designer reading glasses	Group 2
7	7	designer reading glasses	Group 2
8	8	designer reading glasses	Group 2
9	9	designer reading glasses	Group 3
10	10	designer reading glasses	Group 3
11	11	designer reading glasses	Group 3
12	12	designer reading glasses	Group 3
Sheet1

 

[mgm90210M]

thanks


i need please one more thing
i need in column e in your table that every group in cell in the middle of the group
that will write "leader word "

i mean in formula that have odd number like 7 and 9 that have a middle like
="Group " & ROUNDUP(A1/5,0)

 

[FormR]

Like this?

If not it may help for you to post an example of the table with the expected results manually entered.

Excel Workbook
	A	B	C	D	E
1	1	reading glasses	Group 1
2	2	bifocal reading glasses	Group 1		Leader Word
3	3	bifocal reading glasses	Group 1		Leader Word
4	4	foster grant reading glasses	Group 1
5	5	foster grant reading glasses	Group 2
6	6	designer reading glasses	Group 2		Leader Word
7	7	designer reading glasses	Group 2		Leader Word
8	8	designer reading glasses	Group 2
9	9	designer reading glasses	Group 3
10	10	designer reading glasses	Group 3		Leader Word
11	11	designer reading glasses	Group 3		Leader Word
12	12	designer reading glasses	Group 3
Sheet1

 

[FormR]

Or another guess:

Excel Workbook
	A	B	C	D	E
1	1	reading glasses	Group 1		Leader Word
2	2	bifocal reading glasses	Group 1
3	3	bifocal reading glasses	Group 1
4	4	foster grant reading glasses	Group 1
5	5	foster grant reading glasses	Group 2		Leader Word
6	6	designer reading glasses	Group 2
7	7	designer reading glasses	Group 2
8	8	designer reading glasses	Group 2
9	9	designer reading glasses	Group 3		Leader Word
10	10	designer reading glasses	Group 3
11	11	designer reading glasses	Group 3
12	12	designer reading glasses	Group 3
Sheet1

 

[mgm90210M]

a1	b1	c1	d1	e1
reading wqa <tbody> </tbody>	Group 1 <tbody> </tbody> <tbody> </tbody>	1
reading asjk <tbody> </tbody>	Group 1 <tbody> </tbody>	2
sunglass <tbody> </tbody>	Group 1 <tbody> </tbody>	3
reading jkj <tbody> </tbody>	Group 2 <tbody> </tbody>	4
eyeglass <tbody> </tbody>	Group 2 <tbody> </tbody>	5
reading hbhb <tbody> </tbody>	Group 2 <tbody> </tbody>	6
reading knjn <tbody> </tbody>	Group 3 <tbody> </tbody>	7
reading kmk <tbody> </tbody>	Group 3 <tbody> </tbody>	8
reading seas <tbody> </tbody>	Group 3 <tbody> </tbody>	9
reading *** <tbody> </tbody>	Group 4 <tbody> </tbody>	10
reading wkl <tbody> </tbody>	Group 4 <tbody> </tbody>	11
reading ss <tbody> </tbody>	Group 4 <tbody> </tbody>	12
reading ilk <tbody> </tbody>	Group 5 <tbody> </tbody>	13
reading as <tbody> </tbody>	Group 5 <tbody> </tbody>	14
reading qqq <tbody> </tbody>	Group 5 <tbody> </tbody>	15
reading ww <tbody> </tbody>	Group 6 <tbody> </tbody>	16
reading qq <tbody> </tbody>	Group 6 <tbody> </tbody>	17
reading as <tbody> </tbody>	Group 6 <tbody> </tbody>	18

<tbody>
</tbody>

i have 18 word in column a dividing to 6 group
every group have 3 word in that ( 3 is odd number alway will be odd number in every group )
i neet to write in column e for each word if he a leader number
the leader number should be the number in the meddle of each group
like sunglass in a4
or eyeglass in a6

so i need in e4 to write "leader number "
and also in e6



the function or the macro should be consider
that i can change the number of group
and the number of each word in every group

 

[mgm90210M]

a1	b1	c1	d1	e1
reading wqa <tbody> </tbody>	Group 1 <tbody> </tbody> <tbody> </tbody>	1
reading asjk <tbody> </tbody>	Group 1 <tbody> </tbody>	2
sunglass <tbody> </tbody>	Group 1 <tbody> </tbody>	3
reading jkj <tbody> </tbody>	Group 2 <tbody> </tbody>	4
eyeglass <tbody> </tbody>	Group 2 <tbody> </tbody>	5
reading hbhb <tbody> </tbody>	Group 2 <tbody> </tbody>	6
reading knjn <tbody> </tbody>	Group 3 <tbody> </tbody>	7
reading kmk <tbody> </tbody>	Group 3 <tbody> </tbody>	8
reading seas <tbody> </tbody>	Group 3 <tbody> </tbody>	9
reading *** <tbody> </tbody>	Group 4 <tbody> </tbody>	10
reading wkl <tbody> </tbody>	Group 4 <tbody> </tbody>	11
reading ss <tbody> </tbody>	Group 4 <tbody> </tbody>	12
reading ilk <tbody> </tbody>	Group 5 <tbody> </tbody>	13
reading as <tbody> </tbody>	Group 5 <tbody> </tbody>	14
reading qqq <tbody> </tbody>	Group 5 <tbody> </tbody>	15
reading ww <tbody> </tbody>	Group 6 <tbody> </tbody>	16
reading qq <tbody> </tbody>	Group 6 <tbody> </tbody>	17
reading as <tbody> </tbody>	Group 6 <tbody> </tbody>	18

<tbody>
</tbody>

i have 18 word in column a dividing to 6 group
every group have 3 word in that ( 3 is odd number alway will be odd number in every group )
i neet to write in column e for each word if he a leader number
the leader number should be the number in the meddle of each group
like sunglass in a4
or eyeglass in a6

so i need in e4 to write "leader number "
and also in e6



the function or the macro should be consider
that i can change the number of group
and the number of each word in every group

 

[FormR]

Manually enter the expected results in column E and repost the table.

 

[mgm90210M]

sorry i don't understand
i have 2000 row
i need something automatic

a1	b1	c1	d1	e1
reading wqa <tbody> </tbody>	Group 1 <tbody> </tbody> <tbody> </tbody>	1
reading asjk <tbody> </tbody>	Group 1 <tbody> </tbody>	2		leader number
sunglass <tbody> </tbody>	Group 1 <tbody> </tbody>	3
reading jkj <tbody> </tbody>	Group 2 <tbody> </tbody>	4
eyeglass <tbody> </tbody>	Group 2 <tbody> </tbody>	5		leader number
reading hbhb <tbody> </tbody>	Group 2 <tbody> </tbody>	6
reading knjn <tbody> </tbody>	Group 3 <tbody> </tbody>	7
reading kmk <tbody> </tbody>	Group 3 <tbody> </tbody>	8		leader number
reading seas <tbody> </tbody>	Group 3 <tbody> </tbody>	9
reading *** <tbody> </tbody>	Group 4 <tbody> </tbody>	10
reading wkl <tbody> </tbody>	Group 4 <tbody> </tbody>	11		leader number
reading ss <tbody> </tbody>	Group 4 <tbody> </tbody>	12
reading ilk <tbody> </tbody>	Group 5 <tbody> </tbody>	13
reading as <tbody> </tbody>	Group 5 <tbody> </tbody>	14		leader number
reading qqq <tbody> </tbody>	Group 5 <tbody> </tbody>	15
reading ww <tbody> </tbody>	Group 6 <tbody> </tbody>	16
reading qq <tbody> </tbody>	Group 6 <tbody> </tbody>	17		leader number
reading as <tbody> </tbody>	Group 6 <tbody> </tbody>	18

<tbody>
</tbody>

 

[FormR]

Try:

Excel Workbook
	A	B	C	D	E
1	reading wqa	Group 1	1
2	reading asjk	Group 1	2		Leader Number
3	sunglass	Group 1	3
4	reading jkj	Group 2	4
5	eyeglass	Group 2	5		Leader Number
6	reading hbhb	Group 2	6
7	reading knjn	Group 3	7
8	reading kmk	Group 3	8		Leader Number
9	reading seas	Group 3	9
10	reading ***	Group 4	10
11	reading wkl	Group 4	11		Leader Number
12	reading ss	Group 4	12
13	reading ilk	Group 5	13
14	reading as	Group 5	14		Leader Number
15	reading qqq	Group 5	15
16	reading ww	Group 6	16
17	reading qq	Group 6	17		Leader Number
18	reading as	Group 6	18
Sheet1