In excel how do I display every 5th row from sheet 1 and place it in sheet 2?

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)


--
Regards,
Dave


"Tom" wrote:

In excel how do I display every 5th row from sheet 1 and place it in sheet 2?

Now that works I need to take it one more step, I need to remove all dup
records.

"David Billigmeier" wrote:

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)


--
Regards,
Dave


"Tom" wrote:

In excel how do I display every 5th row from sheet 1 and place it in sheet 2?

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!
--
KS


"David Billigmeier" wrote:

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)


--
Regards,
Dave


"Tom" wrote:

In excel how do I display every 5th row from sheet 1 and place it in sheet 2?