Excel 2002: How to speed fill repeatedly ?
 

Dear Sir,

I need to speed fill 1 to 5 in column B repeatedly as illustrated:


A B C
1 1 xxxxx
2 2 xxxxx
3 3 xxxxx
4 4 xxxxx
5 5 xxxxx
6 1 xxxxx
7 2 xxxxx
8 3 xxxxx
9 4 xxxxx
10 5 xxxxx
11 1 xxxxx
12 2 xxxxx
13 3 xxxxx
14 4 xxxxx
15 5 xxxxx
16 1 xxxxx
17 2 xxxxx
18 3 xxxxx
19 4 xxxxx
20 5 xxxxx

May I know what formula must I input at cell B1 and copy down to get the
straight answer ?

Thanks

Low
--
A36B58K641

Excel 2002: How to speed fill repeatedly ?
 

In the first cell enter a 1 and in the cell directly below it enter the
following formula, substituting A1 for the the first cell in the your column:

=IF(A1=5,1,A1+1)

Copy down as far as necessary.

Hope this helps...
--
Kevin Backmann


"Mr. Low" wrote:

Dear Sir,

I need to speed fill 1 to 5 in column B repeatedly as illustrated:


A B C
1 1 xxxxx
2 2 xxxxx
3 3 xxxxx
4 4 xxxxx
5 5 xxxxx
6 1 xxxxx
7 2 xxxxx
8 3 xxxxx
9 4 xxxxx
10 5 xxxxx
11 1 xxxxx
12 2 xxxxx
13 3 xxxxx
14 4 xxxxx
15 5 xxxxx
16 1 xxxxx
17 2 xxxxx
18 3 xxxxx
19 4 xxxxx
20 5 xxxxx

May I know what formula must I input at cell B1 and copy down to get the
straight answer ?

Thanks

Low
--
A36B58K641

Excel 2002: How to speed fill repeatedly ?
 

=MOD(ROW()-1,5)+1
--
David Biddulph

"Mr. Low" wrote in message
...
Dear Sir,

I need to speed fill 1 to 5 in column B repeatedly as illustrated:


A B C
1 1 xxxxx
2 2 xxxxx
3 3 xxxxx
4 4 xxxxx
5 5 xxxxx
6 1 xxxxx
7 2 xxxxx
8 3 xxxxx
9 4 xxxxx
10 5 xxxxx
11 1 xxxxx
12 2 xxxxx
13 3 xxxxx
14 4 xxxxx
15 5 xxxxx
16 1 xxxxx
17 2 xxxxx
18 3 xxxxx
19 4 xxxxx
20 5 xxxxx

May I know what formula must I input at cell B1 and copy down to get the
straight answer ?

Thanks

Low
--
A36B58K641

Excel 2002: How to speed fill repeatedly ?
 

Without a formula...........

B1:B5 enter 1,2,3,4,5

Select all five cells by right-click and drag down as far as you want.

Release button and "Copy Cells"


Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 06:01:01 -0800, Mr. Low
wrote:

Dear Sir,

I need to speed fill 1 to 5 in column B repeatedly as illustrated:


A B C
1 1 xxxxx
2 2 xxxxx
3 3 xxxxx
4 4 xxxxx
5 5 xxxxx
6 1 xxxxx
7 2 xxxxx
8 3 xxxxx
9 4 xxxxx
10 5 xxxxx
11 1 xxxxx
12 2 xxxxx
13 3 xxxxx
14 4 xxxxx
15 5 xxxxx
16 1 xxxxx
17 2 xxxxx
18 3 xxxxx
19 4 xxxxx
20 5 xxxxx

May I know what formula must I input at cell B1 and copy down to get the
straight answer ?

Thanks

Low

Excel 2002: How to speed fill repeatedly ?
 

Hello Kevin,

Thanks for the formula.

It works well,

Best Regards

Low

--
A36B58K641


"Kevin B" wrote:

In the first cell enter a 1 and in the cell directly below it enter the
following formula, substituting A1 for the the first cell in the your column:

=IF(A1=5,1,A1+1)

Copy down as far as necessary.

Hope this helps...
--
Kevin Backmann


"Mr. Low" wrote:

Dear Sir,

I need to speed fill 1 to 5 in column B repeatedly as illustrated:


A B C
1 1 xxxxx
2 2 xxxxx
3 3 xxxxx
4 4 xxxxx
5 5 xxxxx
6 1 xxxxx
7 2 xxxxx
8 3 xxxxx
9 4 xxxxx
10 5 xxxxx
11 1 xxxxx
12 2 xxxxx
13 3 xxxxx
14 4 xxxxx
15 5 xxxxx
16 1 xxxxx
17 2 xxxxx
18 3 xxxxx
19 4 xxxxx
20 5 xxxxx

May I know what formula must I input at cell B1 and copy down to get the
straight answer ?

Thanks

Low
--
A36B58K641

Excel 2002: How to speed fill repeatedly ?
 

Hello David,

Thanks for the formula. It works

Low

--
A36B58K641


"David Biddulph" wrote:

=MOD(ROW()-1,5)+1
--
David Biddulph

"Mr. Low" wrote in message
...
Dear Sir,

I need to speed fill 1 to 5 in column B repeatedly as illustrated:


A B C
1 1 xxxxx
2 2 xxxxx
3 3 xxxxx
4 4 xxxxx
5 5 xxxxx
6 1 xxxxx
7 2 xxxxx
8 3 xxxxx
9 4 xxxxx
10 5 xxxxx
11 1 xxxxx
12 2 xxxxx
13 3 xxxxx
14 4 xxxxx
15 5 xxxxx
16 1 xxxxx
17 2 xxxxx
18 3 xxxxx
19 4 xxxxx
20 5 xxxxx

May I know what formula must I input at cell B1 and copy down to get the
straight answer ?

Thanks

Low
--
A36B58K641

Excel 2002: How to speed fill repeatedly ?
 

Hello Gord,

Thanks for the tip. It works.

Low
--
A36B58K641


"Gord Dibben" wrote:

Without a formula...........

B1:B5 enter 1,2,3,4,5

Select all five cells by right-click and drag down as far as you want.

Release button and "Copy Cells"


Gord Dibben MS Excel MVP

On Wed, 20 Feb 2008 06:01:01 -0800, Mr. Low
wrote:

Dear Sir,

I need to speed fill 1 to 5 in column B repeatedly as illustrated:


A B C
1 1 xxxxx
2 2 xxxxx
3 3 xxxxx
4 4 xxxxx
5 5 xxxxx
6 1 xxxxx
7 2 xxxxx
8 3 xxxxx
9 4 xxxxx
10 5 xxxxx
11 1 xxxxx
12 2 xxxxx
13 3 xxxxx
14 4 xxxxx
15 5 xxxxx
16 1 xxxxx
17 2 xxxxx
18 3 xxxxx
19 4 xxxxx
20 5 xxxxx

May I know what formula must I input at cell B1 and copy down to get the
straight answer ?

Thanks

Low