In B1 enter =INDIRECT("A"&(ROW()-1)*2+1)

Copy down to return every second cell from column A


Gord Dibben MS Excel MVP

On Tue, 13 Jan 2009 02:41:01 -0800, Pete G <Pete G
@discussions.microsoft.com wrote:

Can you fill down such the cell reference goes from A1 to A3 .