Reducing data in a Worksheet

  • Thread starter Thread starter cspellman
  • Start date Start date
C

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.
 
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
 
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
 
Back
Top