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
|