how do i select every other cell in a column? every nth cell?
 

how can i select every other cell in a column? every nth cell? i have a
bunch of data but only want to to perform calculations on some of the points.

Hi

check out
http://www.cpearson.com/excel/excelF.htm#SumEveryNth

for ideas

Cheers
JulieD

"froot_broot" wrote in message
...
how can i select every other cell in a column? every nth cell? i have a
bunch of data but only want to to perform calculations on some of the
points.

That will ADD them. To SELECT them, try the following:
If your data is in A1:A100, enter 1 in B1, X in B2. Select B1:B2,
double-click the fill handle
Now with B1:B100 selected, use edit/goto special, select Constants, deselect
all but "Numbers".
Now you have B1,B3,B5,... selected. Now go to VBA, and enter this in the
immediate window:
Selection.Offset(,-1),Select

and you have it!

Bob Umlas
Excel MVP

"JulieD" wrote in message
...
Hi

check out
http://www.cpearson.com/excel/excelF.htm#SumEveryNth

for ideas

Cheers
JulieD

"froot_broot" wrote in message
...
how can i select every other cell in a column? every nth cell? i have
a
bunch of data but only want to to perform calculations on some of the
points.

Hi Bob

he said that he wanted to "perform calculations on them", so i thought
giving him an example of adding would help :)

Cheers
JulieD

"Bob Umlas" wrote in message
...
That will ADD them. To SELECT them, try the following:
If your data is in A1:A100, enter 1 in B1, X in B2. Select B1:B2,
double-click the fill handle
Now with B1:B100 selected, use edit/goto special, select Constants,
deselect
all but "Numbers".
Now you have B1,B3,B5,... selected. Now go to VBA, and enter this in the
immediate window:
Selection.Offset(,-1),Select

and you have it!

Bob Umlas
Excel MVP

"JulieD" wrote in message
...
Hi

check out
http://www.cpearson.com/excel/excelF.htm#SumEveryNth

for ideas

Cheers
JulieD

"froot_broot" wrote in message
...
how can i select every other cell in a column? every nth cell? i have
a
bunch of data but only want to to perform calculations on some of the
points.

One way for selecting every other, assuming col. A with
header in A1:

1. Copy this into B2 and fill down:
=ISEVEN(ROW())
2. Select both columns.
3. Go into Data Filter AutoFilter.
4. Select TRUE for col. B.
5. Select the range of visible cells in col A (A2:An).
6. Press F5 Special and click "Visible cells only".
7. Remove the filter via Data Filter AutoFilter

HTH
Jason
Atlanta, GA


-----Original Message-----
how can i select every other cell in a column? every
nth cell? i have a
bunch of data but only want to to perform calculations
on some of the points.
.

And for evey "n"th row
=mod(row(),"n")=0
in place of the iseven function below should cover you

On Wed, 23 Mar 2005 08:58:23 -0800, "Jason Morin"
wrote:

One way for selecting every other, assuming col. A with
header in A1:

1. Copy this into B2 and fill down:
=ISEVEN(ROW())
2. Select both columns.
3. Go into Data Filter AutoFilter.
4. Select TRUE for col. B.
5. Select the range of visible cells in col A (A2:An).
6. Press F5 Special and click "Visible cells only".
7. Remove the filter via Data Filter AutoFilter

HTH
Jason
Atlanta, GA


-----Original Message-----
how can i select every other cell in a column? every
nth cell? i have a
bunch of data but only want to to perform calculations
on some of the points.
.