Assuming the column is A

In B1 enter =OFFSET($A$1,2*ROW() -1,0)

Copy down Column B to return every second cell in Column A


Gord Dibben MS Excel MVP


On Thu, 12 Oct 2006 12:25:02 -0700,
wrote:

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.