Excel - Select a column every specific interval

[wwj]

http://groups.google.com/group/microsof ... 482badc218

Code: Select all

To extract every 5th cell in that column, use:
=INDEX(A:A,ROWS($1:1)*5-4) 

Use Pivot Table.
No formulas needed.