skipping every second cell

D

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
 
R

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
 
Top