Reducing data in a Worksheet

[cspellman]

Hello All

I have a very large number of data points, approximately 36000 pairs
that was genrated from a test. I would like to reduce the number of
datasets so it is not so large of a file to manipulate by skipping a
every other row (or maybe 2 or 3 rows). Does anyone now of a formula
or routine to create a new data set in this way?

Thanks.

 

[Pete_UK]

If you put this formula in a blank column next to your data:

=MOD(ROW(),2)

and copy it down, it will give you 1 and 0 alternately. This formula:

=MOD(ROW(),3)

will give 1, 2 and 0 down the column.

You could then apply autofilter to the column and select 0. Highlight
all the rows that are displayed, then Edit | Delete Row. Remove the
filter and your data will have been "squashed". Note that you will
still have the alternating sequence, as the formula will adjust itself
automatically, so you could just repeat the procedure until you have
removed enough data.

Hope this helps.

Pete

 

[Gord Dibben]

In D1 enter this and drag/copy down until you return zeros.

=INDIRECT("A"&ROW(C1)*5) will return every 5th data point in column A.


Gord Dibben MS Excel MVP

 

[cspellman]

Thanks Gord, That did the tric

 

[AShish R.]

Thank you so much Gord Dibben... It worked .. Very helpful.