How to autofill a sequence

R

Randy Pirtle

How can I autofill a sequence like the following.
I would start with:

1
1
2
2
3
3
..... and it would contunue to autofill....
4
4
5
5
6
6
.....
Can this be done without vba coding?
Greatly appreciate any help.
Best Regards
- Randy
 
W

William

Randy

1 Select the relevant range you that already contains the series.
2 With the range selected, point your mouse over the bottom right corner of
the last cell in the range.
3 Right click your mouse and drag down as far as you need.
4 Release the right mouse button and you should be presented with a number
of options - select "Fill Series"


--
XL2002
Regards

William

[email protected]

| How can I autofill a sequence like the following.
| I would start with:
|
| 1
| 1
| 2
| 2
| 3
| 3
| .... and it would contunue to autofill....
| 4
| 4
| 5
| 5
| 6
| 6
| ....
| Can this be done without vba coding?
| Greatly appreciate any help.
| Best Regards
| - Randy
|
 
U

unlikeKansas

William,

Your suggestion didn't work for me. I did as you said and got:

1
1
2
2
3
3
3.6
4.057142857
4.514285714
4.971428571
5.428571429
5.885714286
6.342857143
6.8
7.257142857
7.714285714
8.171428571
8.628571429
9.085714286
9.542857143
10

So I wrote a simple formula to do the fill i.e.

=IF(A5-A6=0,A6+1,A6) and copied it down the range.

unlikeKansas
 
R

Ragdyer

A1 = 1
A3 = 2

Select A1 to A*4*
And drag down as needed.

This will give you a sequential number in all the odd numbered rows.
If it doesn't, try it all over again!

NOW, while the column is *still* selected,
Hit <F5>, then <Special>, then <Blanks>, then <OK>.
NOW, hit equal sign <=>, then <UpArrow>,. then <Ctrl> <Enter>
WHEW ! ! ! You're finally done !
 
D

Debra Dalgleish

Type a 1 in the first two cells, e.g. A1 and A2
In the next cell (A3), type: =A1+1
Select cell A3, and point to the fill handle
(the small black square at the bottom right of the cell)
Drag down as far as you need.
 
R

RagDyeR

Looks like you hit the darned fly with the swatter, while I used the damned
cannon.<g>
--

Regards,

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

Type a 1 in the first two cells, e.g. A1 and A2
In the next cell (A3), type: =A1+1
Select cell A3, and point to the fill handle
(the small black square at the bottom right of the cell)
Drag down as far as you need.
 
N

nowfal

How easy Debra is solving the problem. Very small thing but the way he
explain looks nice. keep it up.
 
Top