Hey Dave When i insert your Function it give me the result like this:

5
10
15
20
25
30
35
40
45
50
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

Hardeep kanwar

"Dave Curtis" wrote:

Hi,
Another method:
Assuming your data is in column A starting in A1, then in B1 enter

=INDIRECT("A"&5*ROW()-4)

and drag down. This will copy the 1st, 6th, 11th 16th etc.

Dave


"Stefi" wrote:

Enter this formula in the 1st row of an empty helper column:

=MOD(ROW()/5,1)=0

Fill it down as necessary!
Autofilter TRUEs in helper column!
EditGotoAdvancedCurrentRegion
EditGotoAdvancedVisible cells only

Copy and paste!


Regards,
Stefi

€žHardeep_kanwar€� ezt Ã*rta:

Hi! Experts

What is the Easiest way to copy Every 5th Row. I have 5000 row and i want to
Copy every 5th Row. Using Formulas not Macros.

Thanks in Advance

Hardeep kanwar