Mod...?

[How_Do_I]

I have data set up as in my Jeanie...

In column C starting at the top I need the first 9 rows to have the number 1... The next 9 rows number 2... etc with the next 9 obviously being 3...

Column D is the same some of thing but it's every 10 rows...

How would I do this please?

Excel Workbook
	B	C	D
1	data	1	1
2	data	1	1
3	data	1	1
4	data	1	1
5	data	1	1
6	data	1	1
7	data	1	1
8	data	1	1
9	data	2	1
10	data	2	1
11	data	2	2
12	data	2	2
13	data	2	2
14	data	2	2
15	data	2	2
16	data	2	2
17	data		2
18	data		2
19	data		2
20	data		2
Sheet1

 

[VoG]

Try in C1 copied down

=1+INT((ROW()-1)/9)

 

[How_Do_I]

Lovely... Thanks Peter.

 

[Scott Huish]

Also:

=-INT(-ROW()/9)

 

[How_Do_I]

Also:

=-INT(-ROW()/9)

That is spot on too thanks HOTPEPPER