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