skipping every second cell
 

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

what is the easiest way to do this?


--
DDOUBLEU
------------------------------------------------------------------------
DDOUBLEU's Profile: http://www.excelforum.com/member.php...o&userid=28674
View this thread: http://www.excelforum.com/showthread...hreadid=483497

skipping every second cell
 

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=483497

skipping every second cell
 

works great!

Thanks


--
DDOUBLEU
------------------------------------------------------------------------
DDOUBLEU's Profile: http://www.excelforum.com/member.php...o&userid=28674
View this thread: http://www.excelforum.com/showthread...hreadid=483497