How do I display every 5th row of data from a worksheet in a new .

J

jct

Need to display every nth row of data from an existing worksheet into a new
worksheet. Any suggestions? Thanks
 
C

CLR

One way would be to use a helper column, listing 1-5, 1-5, 1-5 etc down the
column and then using the AutoFilter to pick out the rows with the 5 on
them.....

Vaya con Dios,
Chuck, CABGx3
 
R

Ragdyer

If the data is in Column A of Sheet1,

To display row 1, 6, 11, ... etc.,
Try this *anywhere* in Sheet2:
=INDEX(Sheet1!A:A,5*ROWS($1:1)-4)

To display Row 5, 10, 15, ...etc.
Try this *anywhere* in Sheet2:
=INDEX(Sheet1!A:A,5*ROWS($1:1))

And copy down as needed.
 

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

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Copying Portions of Data 0
Displaying Returns from another worksheet that change? 3
How can the font and size of (all) citation numbers be altered? 1
how do I copy every 2nd row 5
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
search function 2
Syncing between source worksheet and dependent worksheets 0

Top