formula

[Confusicous]

I have a list of names in Column A and the names appear every 4 lines down.
A2, A6, A10... In column E I just want the names to appear and this has 6,000
lines on the spreadsheet. Can anyone tell me the easiest way to get this to
work out.

Thanks

 

[Gary''s Student]

In E1 enter:

=INDIRECT("A" &4* ROW()-2) and copy down

 

[Mike H]

Hi,

Put this in E1 and drag down as far as required

=INDIRECT("A"&2+(ROW(A1)-1)*4)

Mike

 

[T. Valko]

Select the range of interest.
Right click>Copy
Select the first destination cell
Right click>Paste
With the detination range still selected
Edit>Go to>Special>Blanks>OK
Then Edit>Delete>Shift cells up>OK

 

[Don Guillett]

Sub getevery4throw()
mc = 1 ' col A
r = 2
For i = 2 To Cells(Rows.Count, mc).End(xlUp).Row Step 4
Cells(r, mc + 4) = Cells(i, mc)
r = r + 1
Next i
End Sub

 

[Confusicous]

Thanks a ton! very informative and helpful.

In E1 enter:

=INDIRECT("A" &4* ROW()-2) and copy down