Reducing data in a Worksheet



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?



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


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


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.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question