| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Can I speed fill tabs ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to speed up opening of XML file ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to speed block cells ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : Is there any speed fill formula ? | Excel Discussion (Misc queries) | |||
| Speed fill function for MS Ecel 2007 (Beta) | Excel Worksheet Functions | |||
Linear Mode
