» Retrieving Every nth Value In a Range
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Creating a new list (List2), containing every 3rd value from List1 (Column A).
Solution:
Using the INDEX function as follows:
=INDEX($A$2:$A$13,(ROW()-2)*3+3)
Enter the formula in the first cell of List2, and copy it down.
List1___List2
A_______C
B_______F
C_______I
D_______L
E
F
G
H
I
J
K
L
Book Store:
Recommended Books:
- Microsoft Access 2002 for Dummies
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Excel 2002 Power Programming with VBA
- Microsoft Outlook 2002 for Dummies
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
No comments have been submitted.
