Thanks Domenic. This worked well. The first answer was too difficult
because I have a few thousand entries to sort through but your formula worked
well.


"Domenic" wrote:

Assuming that Sheet1, A2:A100, contains the data, try the following...

1) To return every 4th cell, starting with the first cell in the range...

C2, copied down:

=INDEX(Sheet1!$A$2:$A$100,ROWS($C$2:C2)*4-4+1)

2) To return every 4th cell, starting with the fourth cell in the
range...

C2, copied down:

=INDEX(Sheet1!$A$2:$A$100,ROWS($C$2:C2)*4)

Hope this helps!

In article ,
Chrisinct wrote:

I am working with imported data and I need the information in every 4th cell
for a different worksheet. How can I do this.