selecting every other data point in a column

  • Thread starter Thread starter Joe Troutman
  • Start date Start date
J

Joe Troutman

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
 
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
 
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
 
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
 
Back
Top