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

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

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

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




"jct" wrote:

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

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

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jct" wrote in message
...
Need to display every nth row of data from an existing worksheet into a
new
worksheet. Any suggestions? Thanks