| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-fill numbers in groups of 4
I would like to fill a column with progressive numbers in sets of 4 each.
For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
One way...
In A1 1000 In A2:A4 =A$1 In A5 =A1+1 Drag the formula in A5 down as necessary. -- HTH... Jim Thomlinson "vtrud" wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
Yep, I get how to do that but I don't want to do this all the way up to 2000.
Easier way to auot fill or something? "Jim Thomlinson" wrote: One way... In A1 1000 In A2:A4 =A$1 In A5 =A1+1 Drag the formula in A5 down as necessary. -- HTH... Jim Thomlinson "vtrud" wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
In the first cell of the list, enter your starting number, e.g., 1000.
Then, in the cell below that, enter =$A$5+TRUNC((ROW()-ROW($A$5))/4,0) Change $A$5 to the reference to the first cell in which you entered 1000. Then, copy this formula down for as many rows as you need. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 25 Sep 2009 11:31:02 -0700, vtrud wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
Chip,
You are my most favorite person in the world right now! Thank you!!!! Vicki "Chip Pearson" wrote: In the first cell of the list, enter your starting number, e.g., 1000. Then, in the cell below that, enter =$A$5+TRUNC((ROW()-ROW($A$5))/4,0) Change $A$5 to the reference to the first cell in which you entered 1000. Then, copy this formula down for as many rows as you need. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 25 Sep 2009 11:31:02 -0700, vtrud wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
It is just dragging the formula in A5. You do nt need to write any more
formulas than what is posted. -- HTH... Jim Thomlinson "vtrud" wrote: Yep, I get how to do that but I don't want to do this all the way up to 2000. Easier way to auot fill or something? "Jim Thomlinson" wrote: One way... In A1 1000 In A2:A4 =A$1 In A5 =A1+1 Drag the formula in A5 down as necessary. -- HTH... Jim Thomlinson "vtrud" wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
I do not have a problem with the formula posted but it is good to note that
this formula includes Row which is a volatile function. That means that it not very efficient in terms of calculation. If you have thousands of these formulas you could see a performance hit when the spreadsheet calculates. It is a judgement call as to whether it is a problem or not. -- HTH... Jim Thomlinson "vtrud" wrote: Chip, You are my most favorite person in the world right now! Thank you!!!! Vicki "Chip Pearson" wrote: In the first cell of the list, enter your starting number, e.g., 1000. Then, in the cell below that, enter =$A$5+TRUNC((ROW()-ROW($A$5))/4,0) Change $A$5 to the reference to the first cell in which you entered 1000. Then, copy this formula down for as many rows as you need. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 25 Sep 2009 11:31:02 -0700, vtrud wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
Jim,
I don't know what I did the first time that didn't work, but it is working now. And thank you for this tip too. Have a great weekend. "Jim Thomlinson" wrote: I do not have a problem with the formula posted but it is good to note that this formula includes Row which is a volatile function. That means that it not very efficient in terms of calculation. If you have thousands of these formulas you could see a performance hit when the spreadsheet calculates. It is a judgement call as to whether it is a problem or not. -- HTH... Jim Thomlinson "vtrud" wrote: Chip, You are my most favorite person in the world right now! Thank you!!!! Vicki "Chip Pearson" wrote: In the first cell of the list, enter your starting number, e.g., 1000. Then, in the cell below that, enter =$A$5+TRUNC((ROW()-ROW($A$5))/4,0) Change $A$5 to the reference to the first cell in which you entered 1000. Then, copy this formula down for as many rows as you need. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Fri, 25 Sep 2009 11:31:02 -0700, vtrud wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
Doesn't take too long to drag A5 down to A2000.
But you can select A5 and in the namebox type A5:A2000ENTER Then CTRL + D to copy down. Gord Dibben MS Excel MVP On Fri, 25 Sep 2009 11:50:03 -0700, vtrud wrote: Yep, I get how to do that but I don't want to do this all the way up to 2000. Easier way to auot fill or something? "Jim Thomlinson" wrote: One way... In A1 1000 In A2:A4 =A$1 In A5 =A1+1 Drag the formula in A5 down as necessary. -- HTH... Jim Thomlinson "vtrud" wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-fill numbers in groups of 4
Okay, now Jim and Gord are my most favorite people in the land! You have
made my day! THX. "Gord Dibben" wrote: Doesn't take too long to drag A5 down to A2000. But you can select A5 and in the namebox type A5:A2000ENTER Then CTRL + D to copy down. Gord Dibben MS Excel MVP On Fri, 25 Sep 2009 11:50:03 -0700, vtrud wrote: Yep, I get how to do that but I don't want to do this all the way up to 2000. Easier way to auot fill or something? "Jim Thomlinson" wrote: One way... In A1 1000 In A2:A4 =A$1 In A5 =A1+1 Drag the formula in A5 down as necessary. -- HTH... Jim Thomlinson "vtrud" wrote: I would like to fill a column with progressive numbers in sets of 4 each. For instance, A1 - A4 will have 1000 in them then A5-A8 will have 1001 and so on. Ideas? Thx, V |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Possible to auto-fill in gaps between numbers on straight line bas | Excel Worksheet Functions | |||
| Auto fill numbers and text | Excel Discussion (Misc queries) | |||
| Auto fill numbers starting with zero | Excel Discussion (Misc queries) | |||
| I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
| How do I get auto fill to do decending numbers in a column? | Excel Discussion (Misc queries) | |||
Linear Mode
