» 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:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Marketing Plan: A Handbook with Marketing Plan
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- The New Financial Order: Risk in the Twenty-First Century
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Special Edition Using Microsoft Outlook 2002
No comments have been submitted.
