Need a book? Engineering books recommendations...

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

RE: Excel Question

[Subject Prev][Subject Next][Thread Prev][Thread Next]
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 !
> 
> Thanks in advance,
> Moni Serhal
> 
> 
> 
> 
> 
> 
> 
>