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

 

[mgm90210M]

THANKS

GREEL I HAVE WANT TO TANK YOU


i need one more thing
i need a list in column g
the list of all the word that have "Leader Number" in thar row like
in g1 reading asjk
in g2 eyeglass
in g3 reading kmk

Leader Number

<tbody>
</tbody>

 

[FormR]

With this formula in G1 and copied down maybe:

=INDEX($A$1:$A$18,MATCH((ROWS($G$1:G1)*3)-1,$C$1:$C$18,0))

Excel Workbook
	A	B	C	D	E	F	G
1	reading wqa	Group 1	1				reading asjk
2	reading asjk	Group 1	2		Leader Number		eyeglass
3	sunglass	Group 1	3				reading kmk
4	reading jkj	Group 2	4				reading wkl
5	eyeglass	Group 2	5		Leader Number		reading as
6	reading hbhb	Group 2	6				reading qq
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

 

[mgm90210M]

guies
thanks


you are very good person
and also smart

 

[mgm90210M]

i a sorry
i does not work
it give me also a word that it not Leader Number

 

[mgm90210M]

what change in this formula :
=INDEX($A$1:$A$18,MATCH((ROWS($G$1:G1)*3)-1,$C$1:$C$18,0))


if i want 50 word in every group
and one [FONT=Calibri, Arial]Leader Number in every middle of the group [/FONT]

Leader Number

<tbody>
</tbody>

 

[FormR]

if i want 50 word in every group
and one Leader Number in every middle of the group

Which is the middle number of the group? The 25th or the 26th?

i a sorry
i does not work
it give me also a word that it not Leader Number

Did you get it working for the example you originally gave?

 

[mgm90210M]

in your exemple it work

but i want to change to 49 to word in every group
like this:
="Group " & ROUNDUP(C5420/49,0)

and this for leader number formula :
=(IF(MOD(C5444,49)=25,"Leader Number",""))




i need to this formula: =INDEX($A$1:$A$18,MATCH((ROWS($G$1:G1)*3)-1,$C$1:$C$18,0))
will fit to 2 formula i matches above

 

[FormR]

Like this?

=INDEX($A$1:$A$167,MATCH((ROWS($G$1:G1)*25)-1,$C$1:$C$167,0))

 

[FormR]

On second thoughts:

=INDEX($A$1:$A$500,MATCH((ROWS($G$1:G1)*50)-25-(ROWS($G$1:G1)-1),$C$1:$C$500,0))

Number in group + 1
Number in group divided by 2 plus 1

Excel Workbook
	A	B	C	D	E	F	G
1	Test 1	Group 1	1				Test 25
2	Test 2	Group 1	2				Test 74
3	Test 3	Group 1	3				Test 123
4	Test 4	Group 1	4				Test 172
5	Test 5	Group 1	5
6	Test 6	Group 1	6
7	Test 7	Group 1	7
8	Test 8	Group 1	8
9	Test 9	Group 1	9
10	Test 10	Group 1	10
Sheet1