ok, let me see if i can figure out how to get the chart wizard to swallow
that w/o inserting zeroes for the skipped cells.
thanks!
hwn

"Bill Kuunders" wrote:

insert a helper column with the range 1,2,1,2,1,2,1,2,1,2,
all the way down
sort the two columns by the second column

greetings from NZ
Bill K

" 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.