Thread: how do i specify alternating cell range (de-interleave) in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders Bill Kuunders is offline
external usenet poster
  
Posts: 303
Default how do i specify alternating cell range (de-interleave) in excel?
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.


Reply With QuoteReply With Quote