 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008How do I display every 5th row?
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)  SignatureRegards, Dave > 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. > 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) > > > 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! SignatureKS > 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) > > > In excel how do I display every 5th row from sheet 1 and place it in sheet 2? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.