Interesting. I've used the two before, but not in such a fashion/context.
I know there are many, many permutations which you can use. Such as ...

=INDEX(Sheet1!$A:$A,(ROWS(B$5:B5)-1)*21+1,1)
=INDEX(Sheet1!$A:$A,(ROW(A1)-1)*21+1,1)
=INDEX(Sheet1!$A:$A,ROWS(B$5:B5)*21-20,1)

The list goes on. They should all be safe from row insertions. It's funny
how the ROW reference will be errored out when a row is deleted though, and
not ROWS. I'm assuming this could be chalked up to Excel and it's
calculation and/or function nuances?

Anyway, thanks for the note. Love to learn something every day. :)

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)



"Harlan Grove" wrote in message
oups.com...
Zack Barresse wrote...
You could use something like this ...

=INDEX(Sheet1!$A:$A,(ROW(A1)-1)*21+1,1)

This is assuming that you want to only see the data in each sequential row
in sheet two. Put this formula in a cell, then copy down as needed. It
will only show every 21st row, starting with row 1 of Sheet1.
...

This formula would need to be placed in some cell in Sheet2!1:1 in
order for it to reference Sheet1!A1. Generally safer to use ROWS than
ROW, so if the topmost result cell in Sheet2 were B5, the formula would
be

B5:
=INDEX(Sheet1!$A:$A,ROWS(B$5:B5)*21-20,1)