Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |