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.

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

"Alistair" wrote in message
...
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.

In article , ?B?QWxpc3RhaXI=?= wrote:
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. :)

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.

On Monday, July 28, 2008 11:40 AM Alistai wrote:

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.


On Monday, July 28, 2008 2:31 PM David Biddulph wrote:

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


On Wednesday, July 30, 2008 12:30 AM bruce.sinclai wrote:

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