Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

Re: Excel Question

[Subject Prev][Subject Next][Thread Prev][Thread Next]
"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