Tuesday, July 19, 2005

Finding the Nth value in a range

I thought I would post this one from Exceltip.com as it highlights the use of the ROW function. The ROW and COLUMN functions are very useful for returning the number index of the activecell.

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


Posted by: Jethro | 9:49 AM |