Formula/function for referencing cells in sections of identical data

[bluke12312]

Hello,

I have a rather large worksheet that expands thousands of rows, made up of sections where all sections are identical, just for different groups. On a different sheet how can I automatically reference the same row in each section, in a list from rows 1-22 without manually referencing each row on the new sheet. Each section is made up of 22 rows, each row is identical - 1st row is sales volume in each section, row 18 is commission, etc. I would like to be able to have a list of all group's sales volumes on a different sheet, but without having manually reference each row/column when building the additional list.

I hope this makes sense. Thanks for the help!


Brian

[beaunydal]

=INDEX(Sheet1!A:A,1+(ROW(A1)-1)*22) returns the value in Sheet1!A1
It changes to =INDEX(Sheet1!A:A,1+(ROW(A2)-1)*22) when filled down to the next row and returns the value in Sheet1!A23 (row=1+22), and so on down the column so it returns the values in...
Sheet1!A45 (row=23+22)
Sheet1!A67 (row=45+22)
Sheet1!A89 (row=67+22)
etc.
If you need it to start referencing row 2 instead of row 1 then use =INDEX(Sheet1!A:A,2+(ROW(A1)-1)*22)

Beau Nydal