I have a column of data, say 1 to 100. I want to create a new column with
every other data point, i.e. 1,3,5,7,9.......

What is the best wayto create that?

Thanks

To select every other data point in a column, you can follow these steps:

1. In a new column, enter the formula "=MOD(row_number,2)" in the first cell. This will return a 0 or 1 for each row, indicating whether it is an even or odd row.
2. Copy the formula down the entire column.
3. Select the entire column, including the header.
4. Go to the "Data" tab in the ribbon and click on "Filter".
5. Click on the drop-down arrow in the header of the new column and uncheck the box next to "0".
6. Click "OK" and you will now have a filtered list of every other data point in the original column.

I hope that helps!

Assuming your data starts in A2 put in C2 =A2
then select C2 and C3 together
Click and drag the handle down for the 100 rows, and he formula will only be
in every other row. Then select cells C2 to C100 and copy, then paste special
values, then sort a-z to order numbers to top.
--
If this is the answer you hoped for please remember to click the yes button
below...

Kind regards

Rik


"Joe Troutman" wrote:

I have a column of data, say 1 to 100. I want to create a new column with
every other data point, i.e. 1,3,5,7,9.......

What is the best wayto create that?

Thanks

One easy, generic way

Assume your source data in A2:A100
Put in B2: =INDEX(A$2:A$100,ROWS($1:1)*2-1)
Copy down as far as required to exhaust.

The series generator for 1,3,5,7,...
is: ROWS($1:1)*2-1

You could place in any startcell: =ROWS($1:1)*2-1
and copy down to see the series gen

Hence plugging the above into: INDEX(SourceCol,SeriesGenerator)
and copying down will return exactly what you seek

Success? hit the YES below
--
Max
Singapore
---
"Joe Troutman" wrote:
I have a column of data, say 1 to 100. I want to create a new column with
every other data point, i.e. 1,3,5,7,9.......

What is the best way to create that?

Thanks

Hi,

Let's say 1 to 100 is in range C6:C105. In C5, type numbers. In E6, type
=isodd(c6). In E5, type Condition. Now go to Data Filter Advanced
Filter and select Copy to another location. In the list range, select
C5:C105. In criteria range, select E5:E6. Now click on OK

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Joe Troutman" <Joe wrote in message
...
I have a column of data, say 1 to 100. I want to create a new column with
every other data point, i.e. 1,3,5,7,9.......

What is the best wayto create that?

Thanks