On Sunday, January 27, 2008 5:59:00 AM UTC+7, Max wrote:
"rickhoff" wrote:
.. select every 4th or 5th cell in that column

If source data is in A1 down,
to extract every 4th cell in that column

Put this in any starting cell desired, say in E2:
=INDEX(A:A,ROWS($1:1)*4-3)
Copy down as far as required

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

And so on. Adapt to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Great!