selecting every second row

[John Kurby]

I have 100,000 rows of data, but i only want to lot every seecond row of
data.
does anybody know how to make a new colmn, that will select every second row
of the other colmn?

I dont want to do it by hand

Thanks

 

[Frank Kabel]

Hi
enter the following in cell B1
=OFFSET($A$1,(ROW()-1)*2,0)
and copy this down

 

[John Kurby]

Thanks, works like a charm

Hi
enter the following in cell B1
=OFFSET($A$1,(ROW()-1)*2,0)
and copy this down