Tip Printed from ExcelTip.com

---

Retrieving Every Nth Value in a Range


Problem:

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)