decimate rows in Excel 2007

[Alistair]

I have a large spreadsheet, about 23000 rows. I want to reduce this to about
700 rows by decimating the sheet and keeping, say, every 40th row. How can I
do this?
Look forward to hearing from you.

 

[David Biddulph]

=MOD(ROW(),40) in a helper coulumn, and auto-filter.

 

[Bruce Sinclair]

I have a large spreadsheet, about 23000 rows. I want to reduce this to about
700 rows by decimating the sheet and keeping, say, every 40th row. How can I
do this?
Look forward to hearing from you.

As an aside, 'decimate' means to lose 1 out of 10.

 

[J DK]

I find it MUCH easier to make a column with row numbers of the rows I want to keep and use the "indirect" function.

For example if the data I want to resample or decimate is in column A, put the following in column B to keep every 20th data point:
20
40
60
80
100
....
Then use the indirect function in the next column, Column C in this case:
=indirect(concatenate("A",B1))
copy and paste to the end of the list in column B.
Column C then contains every nth (20th in example) data point.