View Single Post
  #1   Report Post  
Bob Tarburton
 
Posts: n/a
Default

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.
.