skipping every second cell

[DDOUBLEU]

I wish to have in col B every second entry in col A; for example A1 i
B1, A3 in B2, A5 in B3, A7 in B4.....

what is the easiest way to do this

 

[Ron Coderre]

For data beginning in Cell A1 and continuing down:
B1: =OFFSET($A$1,ROWS($A$1:A1)*2-1,,,)

Copy that formula down.

Does that help?

••••••••••
Regards,
Ron

 

[DDOUBLEU]

works great!

Thanks