G Guest May 25, 2006 #1 In excel how do I display every 5th row from sheet 1 and place it in sheet 2?
G Guest May 25, 2006 #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)
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)
G Guest May 25, 2006 #3 Now that works I need to take it one more step, I need to remove all dup records.
K KS Mar 14, 2008 #4 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!
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!
