Copy every other row

eqbal

Board Regular
Joined
Sep 6, 2002
Messages
92
HI

I have a worksheet and I want to copy the contents of every other row for 400 rows like below with drag and fill. Excel does not understand the algorithm. How can I do that? It's 400 rows!! This goes on for columns B to F too. Pls help.


[A2]=IF(H2<>"",H2,"")
[A3]=IF(H4<>"",H4,"")
[A4]=IF(H6<>"",H6,"")
.
.
.
[A400]=IF(H800<>"",H800,"")
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,496
I'm fairly sure U need to use vba. If U want some code please specify exactly what sheet, columns and rows U want transferred as well as exactly where U want them to go. HTH. Dave
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Try

=IF(INDEX(H:H,(ROWS(A$1:A1)-1)*2+2)="","",INDEX(H:H,(ROWS(A$1:A1)-1)*2+2))

DON'T change the A$1:A1 reference, it's not related to your data.
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
What type of data is in column H, if it's text this can be simplified greatly

=T(INDEX(H:H,(ROWS(A$1:A1)-1)*2+2))
 

yujin

New Member
Joined
Jan 25, 2018
Messages
2
Modify your formula like below and drag & fill

[A2]=IF(INDIRECT("H"&(ROW(A2)-1)*2)<>"",INDIRECT("H"&(ROW(A2)-1)*2),"")
 

Watch MrExcel Video

Forum statistics

Threads
1,108,751
Messages
5,524,616
Members
409,595
Latest member
therevford

This Week's Hot Topics

Top