software

Hi, here's a plain example of what I'm trying to do:
In cell B1 is the formula: =A1
In cell B2 is the formula: =A1
In cell B3 is the formula: =A2
In cell B4 is the formula: =A2
In cell B5 is the forumla: =A3
In cell B6 is the formula: =A3

(you can see where this is heading..)

The problem I have is that I want to use the fill handle to copy this
series down a whole column, however Excel just won't see the pattern
here! (or I'm missing something obvious)

Help please! --
jhct
------------------------------------------------------------------------
jhct's Profile: www.excelforum.com/member.php...oamp;userid=31562
View this thread: www.excelforum.com/showthread...hreadid=512566See reply in .Excel

Biff

quot;jhctquot; gt; wrote in message
...
gt;
gt; Hi, here's a plain example of what I'm trying to do:
gt; In cell B1 is the formula: =A1
gt; In cell B2 is the formula: =A1
gt; In cell B3 is the formula: =A2
gt; In cell B4 is the formula: =A2
gt; In cell B5 is the forumla: =A3
gt; In cell B6 is the formula: =A3
gt;
gt; (you can see where this is heading..)
gt;
gt; The problem I have is that I want to use the fill handle to copy this
gt; series down a whole column, however Excel just won't see the pattern
gt; here! (or I'm missing something obvious)
gt;
gt; Help please!
gt;
gt;
gt; --
gt; jhct
gt; ------------------------------------------------------------------------
gt; jhct's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31562
gt; View this thread: www.excelforum.com/showthread...hreadid=512566
gt;

sorry i dont' follow...I've searched this topic and couldnt' find
anything, can you please clarify. thanks--
jhct
------------------------------------------------------------------------
jhct's Profile: www.excelforum.com/member.php...oamp;userid=31562
View this thread: www.excelforum.com/showthread...hreadid=512566Select cells B1 and B2
grab the autofill handle and drag down as required.

Hans
cheers for the response Hans, I tried this first but it doesn't work.
Excel populates the following formulas down column B when dragging the
fill handle:
=A1
=A1
=A2
=A2
=A5 lt;lt; it skips 3 here
=A5
=A6
=A6
=A9 lt;lt; skips another 3
=A9
=A10
=A10 etc.....(continues to do this)

Any other sugesstions?--
jhct
------------------------------------------------------------------------
jhct's Profile: www.excelforum.com/member.php...oamp;userid=31562
View this thread: www.excelforum.com/showthread...hreadid=512566It does work, look at this example

11
21
33
43
55
65
77
87
99
119
2222
3322
4444
5544
6666
7766
8888
9988

Could you try again?

HansAre there maybe any hidden rows?

Hans
There are no hidden rows, I will clarify what I mean with an image.

What I want to do is use the fill handle to repeat this series down
colum B. So I want cells B5 and B6 to populate as =A3, then the next 2
cells down =A4.Your example above goes up in odd numbers missing all the even numbers
in between, which is my problem. I need each 2 cells to be the next
consecutive number. -------------------------------------------------------------------
|Filename: example.JPG |
|Download: www.excelforum.com/attachment.php?postid=4364 |
-------------------------------------------------------------------

--
jhct
------------------------------------------------------------------------
jhct's Profile: www.excelforum.com/member.php...oamp;userid=31562
View this thread: www.excelforum.com/showthread...hreadid=512566Hi!

gt;See reply in .Excel

gt;gt;sorry i dont' follow...I've searched this topic and couldnt'
gt;gt;find anything, can you please clarify. thanks

You have workable solutions at your other post in the Public.Excel group.

While you're getting nowhere in this thread the solution has already been
provided. This is why multi-posting is a bad idea!

Enter this formula in B1 and copy down as needed:

=INDEX(A:A,CEILING(ROWS($1:1)/2,1))

Biff

quot;jhctquot; gt; wrote in message
...
gt;
gt; There are no hidden rows, I will clarify what I mean with an image.
gt;
gt; What I want to do is use the fill handle to repeat this series down
gt; colum B. So I want cells B5 and B6 to populate as =A3, then the next 2
gt; cells down =A4.
gt;
gt;
gt; Your example above goes up in odd numbers missing all the even numbers
gt; in between, which is my problem. I need each 2 cells to be the next
gt; consecutive number.
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: example.JPG |
gt; |Download: www.excelforum.com/attachment.php?postid=4364 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; jhct
gt; ------------------------------------------------------------------------
gt; jhct's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31562
gt; View this thread: www.excelforum.com/showthread...hreadid=512566
gt;

Say you want your sequence for 100 cells.

You could try putting =a1 in both cells B1 and C1, etc, through row 50,
then drag the range C1:C50 down to B51. Fill col C the consecutive
sequence 1,2,3,etc for the range c1:c50, and again for C51:C100. Then
sort B1:C100 on col C. this shoudl give you what you're after.

---Glenn--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=512566