» Retrieving Every Nth Value in a Range
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Creating a new list (List2), which consists of every 3rd value from List1.
Solution:
Use the INDEX and ROW functions as shown in the following formula:
=INDEX($A$2:$A$13,(ROW()-2)*3+3)
Book Store:
Recommended Books:
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Keys to Reading an Annual Report (Barron's Business Keys)
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Investing for Dummies, Third Edition
No comments have been submitted.
