Need a book? Engineering books recommendations...

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

RE: Excel Question

[Subject Prev][Subject Next][Thread Prev][Thread Next]

I have two equations that will work.  If you always start at row 1 (i.e.
B1=A1), then use this simplified formula: B1=offset(A1,row(A1)-1,0), and
copy the formula down.  A more generic formula, works for situation like
(B2=A2, B3=A4...) is: B1=offset($A$1,(row(b1)-row($b$1))*2,0).

Hope this help.


Frank Yang, P.E.
Senior Engineer                                   BERGER/ABAM Engineers Inc
Voice: 206-431-2374                                33301 Ninth Avenue South
Fax:   206-431-2250                             Federal Way, WA  98003-6395
e-mail: yang(--nospam--at)                         

-----Original Message-----
From: Sleiman Serhal [mailto:mony(--nospam--at)]
Sent: Tuesday, February 16, 1999 3:02 AM
To: seaint(--nospam--at)
Subject: Excel Question

Hello everybody,

I'm trying to work out something in Excel but it ain't working so maybe
out there can help:

I want to fill down a column, let's say column B, and have it fill down
B1 = A(1)
B2 = A(3)
B3 = A(5)
B4 = A(7)

So I want the fill down in B to pick up the cells at column A in
increments of
2 !

Thanks in advance,
Moni Serhal