How do I display every 5th row?

  • Thread starter Thread starter Guest
  • Start date Start date
Use something like this, might have to personalize it because I assumed both
data sets began in A1:

=OFFSET(Sheet1!$A$1,ROW()*5-1,0)
 
I am trying to do a similar task, but for me it's every 27th row.

I tried using the formula you provided for Tom, but I received an "invalid"
error.

This is the formula I used: =OFFSET('Elem Bnchmrk'!$B$17:$C$17,ROW()*27-1,0)

Please help!
 

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

how do I copy every 2nd row 5
Referencing every 5th cell in another sheet 4
sorting out rows 2
how do I copy specific rows without copying each row individually 3
Converting Rows into Columns 3
Add a Row Every Fourth Row 3
Change Color on rows, after an IF Funtion is answered 4
Averaging every 5th cell while omitting zeros 4

Back
Top