Need a book? Engineering books recommendations...

• To: seaint(--nospam--at)seaint.org
• Subject: Re: Excel Question -Reply
• From: John Armijo <421jarmi(--nospam--at)pwcsd.nosc.mil>
• Date: Tue, 16 Feb 1999 09:03:31 -0800

```Try
B1=+A1
B2=+A3
Copy +A3 to B3 through Bn

>>> Sleiman Serhal <mony(--nospam--at)destination.com.lb> 02/16/99 09:16am >>>
"P.Rajendran" wrote:

> In cell B1, enter the formula "=A1" and in cell B2 enter formula "=A3".
> Highlight both cells B1 and B2. Select copy from "Edit" menu.  Highlight
> B3, B4 etc as far as you want to go and select paste from "Edit" menu.
>
> Rajendran
>
> Sleiman Serhal wrote:
>
> > Hello everybody,
> >
> > I'm trying to work out something in Excel but it ain't working so maybe
> > someone
> > out there can help:
> >
> > I want to fill down a column, let's say column B, and have it fill down
> > as
> > follows
> > B1 = A(1)
> > B2 = A(3)
> > B3 = A(5)
> > B4 = A(7)
> > etc...
> >
> > So I want the fill down in B to pick up the cells at column A in
> > increments of
> > 2 !

Humm, thanks for the try but it doesn't work like this cause cells in column
B will be as follows:
B1=A1
B2=A3
B3=A3
B4=A5
B5=A5
B6=A7
etc...
plus we can't paste areas that are different from the copied ones

Moni Serhal

```