How do I create a sample in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a sample, needing every 20th record out of around 3000
records.
 
Mary,

You need a VBA procedure.

Sub AAA()
Dim RowNdx As Long
Dim DestRng As Range
Set DestRng = Worksheets("Sheet2").Range("A1")
For RowNdx = 1 To 3000 Step 20
Rows(RowNdx).Copy Destination:=DestRng
Set DestRng = DestRng(2, 1)
Next RowNdx
End Sub



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating median of time period 3
How to sample data without returning duplicates? 6
How do I make a random sample? 4
Return Random Sampling from Query 2
Creating Drop Box Lists 2
How do I write Sample across a spreadsheet? 6
Random Samples 1
Excel How to create a stacked bar graph 0

Back
Top