Excel row removal/selectionClosed

Question

Hello,
I am trying to select certain rows from a very large data sheet. Ideally I would like to select every 25th row so as to get a random sample of data. 
I've tried filters, row functions & formulas but nothing seems to work.
I'd appreciate any suggestions.
Many thanks,
KO

Ivan-hoe · Accepted Answer

Hello, 
I do not think there is any solution with filters ; using formulas would be quite complicated. I suggest you use the macro below, which selects every 25th row from row 2.
Sub Kateo()
    Dim MyRange As Range, i As Integer
    Set MyRange = Rows(2)
    For i = MyRange.Row To Cells(Rows.Count, "A").End(xlUp).Row Step 25
        Set MyRange = Union(MyRange, Rows(i))
    Next i
    MyRange.Select
End Sub
Ivan

Umeshkumar · Answer

I can send you sheet to extract every nth or 25 th row of the total records.
Please reply me if you need it.

amaresh · Answer

hello umesh,

i use this formula when i want to select every nth row. Try this out.

=mod(row(a1),3)


where 3 refers to nth row. If you are in need of 25th row, =mod(row(a1),25) & then use filters.

thanks,
amaresh

Excel row removal/selection

3 responses

Similar discussions

Subscribe To Our Newsletter!