» Retrieving Every nth Value In a Range
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: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:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Microsoft Office XP Introductory Concepts and Techniques
- Special Edition Using Microsoft Excel 2002
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
No comments have been submitted.
