Posted to microsoft.public.excel.misc
|
|
Filling a series
See reply in .Excel
Biff
"jhct" wrote in message
...
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:
http://www.excelforum.com/member.php...o&userid=31562
View this thread: http://www.excelforum.com/showthread...hreadid=512566
|