Need a book? Engineering books recommendations...

# RE: Excel Question

• To: "'seaint(--nospam--at)seaint.org'" <seaint(--nospam--at)seaint.org>
• Subject: RE: Excel Question
• From: "Serroels, Chris/SAC" <CSerroel(--nospam--at)CH2M.com>
• Date: Tue, 16 Feb 1999 11:25:29 -0700

One more option:

But before I describe it (yes, there's a catch) - Doesn't anyone have any
thoughts on
my question yesterday regarding what constitutes "threads excluded" for a
high strength bolt.

1)  Column B Row 1, "x=A1" (doesn't have to be x, just any character which
makes
Excel recognize this cell as text, not an equation)

2)  Column B Row 2, "x=A3"

3) Highlight both cells and then drag bottom of highlighted box

4) Excel automatically fills in "x=A5", "x=A7", ... in following Column B
cells

5) Now perform a search and replace, replacing "x=" with "=".  This will
convert all
Column B cells to equations.

> -----Original Message-----
> From:	Frank Yang [SMTP:yang(--nospam--at)abam.com]
> Sent:	Tuesday, February 16, 1999 9:48 AM
> To:	seaint(--nospam--at)seaint.org
> Subject:	RE: Excel Question
>
> Sieiman,
>
> 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
>
> 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)abam.com
> http://www.abam.com
>
> -----Original Message-----
> From: Sleiman Serhal [mailto:mony(--nospam--at)destination.com.lb]
> Sent: Tuesday, February 16, 1999 3:02 AM
> To: seaint(--nospam--at)seaint.org
> Subject: Excel Question
>
>
> 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 !
>