Problems with Auto-Fill

  • Thread starter Thread starter Randy Pirtle
  • Start date Start date
R

Randy Pirtle

I am having problems with auto-fill.
I am using Office 2003.

I try to autofill the following sequence in Excell:
1
1
2
2
3
3

I highlight the sequence, right-click on the right bottom
most handle, drag-down.... as I do I select "Fill Series".
I see continued:
3.6
4.057142857
4.514285714
4.971428571
5.428571429

.... while I had hoped to see:
4
4
5
5
6
6

Any advice would be appreciated.

Thanks!
 
You asked this same question on 8/11, and received several answers.

Perhaps you didn't even bother to check to see if your post received any
suggestions.

http://tinyurl.com/5mv3r


--



Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

I am having problems with auto-fill.
I am using Office 2003.

I try to autofill the following sequence in Excell:
1
1
2
2
3
3

I highlight the sequence, right-click on the right bottom
most handle, drag-down.... as I do I select "Fill Series".
I see continued:
3.6
4.057142857
4.514285714
4.971428571
5.428571429

.... while I had hoped to see:
4
4
5
5
6
6

Any advice would be appreciated.

Thanks!
 
RD,

In Randy's defense, I had a look at all of the replies on 8/11 and NONE of
them offered an answer to the CURRENT question, which is why auto-fill
generates those peculiar numbers. I'm kind of curious myself as to the
significance of this sequence.

Ryan Poth
 
I tried the reply I recieved on the 11th, and I did not
get the progressive increase in the number sequence I was
looking for, but rather a repetition of the same number
sequence.

At the time, I had thought I had received the answer I was
looking for but days later realized this did not meet my
need.

Best Regards
 
One alternative to play around with:

Try in any "start" cell, say in E5
: =INT((ROW(A1)-1)/2) + 1

Copy down
 
The main question *WAS*, and as far as I can read, *STILL IS*,
how to create a series of double incrementing numbers down a column.
1
1
2
2
3
3
....etc.

Debra's solution and mine, *DO* fulfill this request !!!

Hers *much* more easily and simpler then mine, BUT, both do work.

Now, you state the *Current" question.

<<"... while I had hoped to see:
4
4
5
5
6
6

Any advice would be appreciated">>

That sounds to me like he wants advice on how to accomplish the creation of
the requested number series.

Doesn't sound like he's asking for an explanation.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------



RD,

In Randy's defense, I had a look at all of the replies on 8/11 and NONE of
them offered an answer to the CURRENT question, which is why auto-fill
generates those peculiar numbers. I'm kind of curious myself as to the
significance of this sequence.

Ryan Poth
 
It depends on what you want to happen if you insert or delete
rows within the numbered sequence.

If you are look for the formula to adjust for insertion/deletion
of rows like =ROWS()-1 might do if started in cell A2
then the comparable formula that Max provide might be rewritten as:

starting form Row 1 as A1: =INT((ROW()-1)/2)+1
starting from Row 2 as B2: =INT((ROW()-2)/2)+1
starting from Row 5 as C5: =INT((ROW()-5)/2)+1

Use the fill handle to copy the formula down.

So if you deleted rows within the numbering no changes needed,
But if you inserted rows within the numbering simply use the fill
handle to fill in the missing gaps after inserting rows.

None of the the other solutions (Max, Debra, Ragdyer) made this
adjustment. Depends on what you actually want to happen when
inserting / deleting rows. So this may help you or it may not.
 
I think I solved your problem - at least the way that I
understand it. You want a list to autofill in 2's. For
example:
1
1
2
2
3
3
and then click and drag to produce
4
4
5
5
and so on - correct?

Once I typed the first 6 cells into cells A1-A6
(1,1,2,2,3,3) as above, I hilighted them all then right
clicked and chose Format Cells. I chose the Number tab at
the top, then highlighted "Number" in the list on the
left. Then on the right, I typed "0" for Decimal places,
then clicked OK.

Back to my list, I skipped A1 but hilighted cells A2 to A6
by right -clicking and dragging. Then I right clicked the
bottom right corner of A6 and dragged down a bunch of
cells. This produced the list I wanted:
1
1
2
2
3
3
4
4
5
5
and so on. It's important not to select the top cell
because for some reason, it produces a triple number.

I believe the reason you were producing those big long
numbers before was because of the decimal places in the
formatting.

Anyway - sure hope it helps you.
 
Back
Top