For even numbered rows, try this:

=INDEX(A:A,2*ROWS($1:1))

And copy down as needed.

For odd numbered rows, try this:

=INDEX(A:A,2*ROWS($1:1)-1)

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

" wrote in
message ...
given two sets of numbers which have been interleaved/alternated in (e.g)
a
column, how can i specify a range that returns every other cell?
thanks.