|
-
May 10th, 2006, 03:38 PM
#1
Thread Starter
Addicted Member
Excel: pulling index data out of data set
I have a(1) column of data in excel and I would like to pull every 60th (example: 60,120,180) data points out of the column. How do I do this? VBA may be the way but I have never done any.
The index function in excel does not work well:
example:
Index(A1:An,C1) where C1 = the Interval (60th), it returns a result that is 3 or 4 indexes down from the correct value.
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|