software

I have the following:
cell G1 = A2
cell G2 = A4
cell G3 = A6

Is there a way to have this go all the way down the column. I know if the
cells equaled A2, A3, A4 I could just drag it down but it doesn't work in
this case. Any ideas? Thanks

Try the following formula

=INDIRECT(quot;Aquot;amp;ROW()*2)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;Jambruinsquot; gt; wrote in
message
...
gt;I have the following:
gt; cell G1 = A2
gt; cell G2 = A4
gt; cell G3 = A6
gt;
gt; Is there a way to have this go all the way down the column. I
gt; know if the
gt; cells equaled A2, A3, A4 I could just drag it down but it
gt; doesn't work in
gt; this case. Any ideas? Thanks
Actually this is what the exact cells a

G1:=ODDS!C2
G2:=ODDS!C4
G3:=ODDS!C6

How would I alter the formula you provided me with in this case? Thanks.

quot;Chip Pearsonquot; wrote:

gt; Try the following formula
gt;
gt; =INDIRECT(quot;Aquot;amp;ROW()*2)
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt; quot;Jambruinsquot; gt; wrote in
gt; message
gt; ...
gt; gt;I have the following:
gt; gt; cell G1 = A2
gt; gt; cell G2 = A4
gt; gt; cell G3 = A6
gt; gt;
gt; gt; Is there a way to have this go all the way down the column. I
gt; gt; know if the
gt; gt; cells equaled A2, A3, A4 I could just drag it down but it
gt; gt; doesn't work in
gt; gt; this case. Any ideas? Thanks
gt;
gt;
gt;

Hi!

Try this:

=INDEX(odds!C:C,(ROWS($1:2)-1)*2)

Biff

quot;Jambruinsquot; gt; wrote in message
...
gt; Actually this is what the exact cells a
gt;
gt; G1:=ODDS!C2
gt; G2:=ODDS!C4
gt; G3:=ODDS!C6
gt;
gt; How would I alter the formula you provided me with in this case? Thanks.
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt;gt; Try the following formula
gt;gt;
gt;gt; =INDIRECT(quot;Aquot;amp;ROW()*2)
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Cordially,
gt;gt; Chip Pearson
gt;gt; Microsoft MVP - Excel
gt;gt; Pearson Software Consulting, LLC
gt;gt; www.cpearson.com
gt;gt;
gt;gt;
gt;gt; quot;Jambruinsquot; gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; gt;I have the following:
gt;gt; gt; cell G1 = A2
gt;gt; gt; cell G2 = A4
gt;gt; gt; cell G3 = A6
gt;gt; gt;
gt;gt; gt; Is there a way to have this go all the way down the column. I
gt;gt; gt; know if the
gt;gt; gt; cells equaled A2, A3, A4 I could just drag it down but it
gt;gt; gt; doesn't work in
gt;gt; gt; this case. Any ideas? Thanks
gt;gt;
gt;gt;
gt;gt;
Try:

=INDIRECT(quot;ODDS!Cquot;amp;ROW(1:1)*2)

HTH
JG

quot;Jambruinsquot; wrote:

gt; Actually this is what the exact cells a
gt;
gt; G1:=ODDS!C2
gt; G2:=ODDS!C4
gt; G3:=ODDS!C6
gt;
gt; How would I alter the formula you provided me with in this case? Thanks.
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt; gt; Try the following formula
gt; gt;
gt; gt; =INDIRECT(quot;Aquot;amp;ROW()*2)
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Cordially,
gt; gt; Chip Pearson
gt; gt; Microsoft MVP - Excel
gt; gt; Pearson Software Consulting, LLC
gt; gt; www.cpearson.com
gt; gt;
gt; gt;
gt; gt; quot;Jambruinsquot; gt; wrote in
gt; gt; message
gt; gt; ...
gt; gt; gt;I have the following:
gt; gt; gt; cell G1 = A2
gt; gt; gt; cell G2 = A4
gt; gt; gt; cell G3 = A6
gt; gt; gt;
gt; gt; gt; Is there a way to have this go all the way down the column. I
gt; gt; gt; know if the
gt; gt; gt; cells equaled A2, A3, A4 I could just drag it down but it
gt; gt; gt; doesn't work in
gt; gt; gt; this case. Any ideas? Thanks
gt; gt;
gt; gt;
gt; gt;

chip, biff, and pin, thanks for the help!

quot;pinmasterquot; wrote:

gt; Try:
gt;
gt; =INDIRECT(quot;ODDS!Cquot;amp;ROW(1:1)*2)
gt;
gt; HTH
gt; JG
gt;
gt; quot;Jambruinsquot; wrote:
gt;
gt; gt; Actually this is what the exact cells a
gt; gt;
gt; gt; G1:=ODDS!C2
gt; gt; G2:=ODDS!C4
gt; gt; G3:=ODDS!C6
gt; gt;
gt; gt; How would I alter the formula you provided me with in this case? Thanks.
gt; gt;
gt; gt; quot;Chip Pearsonquot; wrote:
gt; gt;
gt; gt; gt; Try the following formula
gt; gt; gt;
gt; gt; gt; =INDIRECT(quot;Aquot;amp;ROW()*2)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Cordially,
gt; gt; gt; Chip Pearson
gt; gt; gt; Microsoft MVP - Excel
gt; gt; gt; Pearson Software Consulting, LLC
gt; gt; gt; www.cpearson.com
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Jambruinsquot; gt; wrote in
gt; gt; gt; message
gt; gt; gt; ...
gt; gt; gt; gt;I have the following:
gt; gt; gt; gt; cell G1 = A2
gt; gt; gt; gt; cell G2 = A4
gt; gt; gt; gt; cell G3 = A6
gt; gt; gt; gt;
gt; gt; gt; gt; Is there a way to have this go all the way down the column. I
gt; gt; gt; gt; know if the
gt; gt; gt; gt; cells equaled A2, A3, A4 I could just drag it down but it
gt; gt; gt; gt; doesn't work in
gt; gt; gt; gt; this case. Any ideas? Thanks
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;