Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please Help...How can I do this? Select a cell | Excel Worksheet Functions | |||
Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting row if cell value in certain column is even | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions |