Sep 24 2021 07:05 AM
I have the need to make a spreadsheet where I am duplication a row from another sheet (Purchase line and a Tax Line)
When I highlight the first 4 cells and pull down for auto fill you can see it goes from i2 i2 > i3 i3 to i6 i6 >i7 to i10 and so on
I need it to go from i2 i2 > i3 i3 >i4 i4 > i5 i5 and so on see below any assistance would be great
=IF('Paste Service Date'!I2> 0,'Paste Service Date'!I2,"")
=IF('Paste Service Date'!I2> 0,'Paste Service Date'!I2,"")
=IF('Paste Service Date'!I3> 0,'Paste Service Date'!I3,"")
=IF('Paste Service Date'!I3> 0,'Paste Service Date'!I3,"")
=IF('Paste Service Date'!I6> 0,'Paste Service Date'!I6,"")
=IF('Paste Service Date'!I6> 0,'Paste Service Date'!I6,"")
=IF('Paste Service Date'!I7> 0,'Paste Service Date'!I7,"")
=IF('Paste Service Date'!I7> 0,'Paste Service Date'!I7,"")
=IF('Paste Service Date'!I10> 0,'Paste Service Date'!I10,"")
=IF('Paste Service Date'!I10> 0,'Paste Service Date'!I10,"")
=IF('Paste Service Date'!I11> 0,'Paste Service Date'!I11,"")
=IF('Paste Service Date'!I11> 0,'Paste Service Date'!I11,"")
=IF('Paste Service Date'!I14> 0,'Paste Service Date'!I14,"")
=IF('Paste Service Date'!I14> 0,'Paste Service Date'!I14,"")
=IF('Paste Service Date'!I15> 0,'Paste Service Date'!I15,"")
Sep 24 2021 08:08 AM
Let's say the first formula is in row 2. Enter
=IF(INDEX('Paste Service Date'!I:I,QUOTIENT(ROW()+2,2))>0,INDEX('Paste Service Date'!I:I,QUOTIENT(ROW()+2,2)),"")
and fill down. If the first formula is in another row, you'll have to change the +2: subtract 1 for each row down. So for example if the first formula is in row 5, use -1 instead of 2