Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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.
.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please Help...How can I do this? Select a cell zoombr Excel Worksheet Functions 1 March 23rd 05 08:34 PM
Conditional Formatting Deb Excel Discussion (Misc queries) 7 March 6th 05 03:37 PM
Conditional formatting row if cell value in certain column is even Hyland Hunt Excel Worksheet Functions 1 February 2nd 05 08:21 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Excel - option to extend function in cell to column kjoshua777 Excel Worksheet Functions 2 November 18th 04 01:08 AM


All times are GMT +1. The time now is 07:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"