Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. . |
#6
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
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 |