Data-reduction in coloumns???

R

Ralv

Hi!

I´m looking for a way of data-reduction. I have a lot of data-point
but only want to use every 10th point. Is there a way to pic out onl
every tenth data-point?
Thanks for helping!!
 
B

Bernie Deitrick

Ralv,

In the next column, enter 1 through 10 in the first ten cells. Copy those,
then paste to match your data. Sort both columns based on the column of 1
to 10. If you don't need to keep all your data, delete all but one number's
worth of data, otherwise, copy it somewhere else, then unsort it and delete
your column o fextra numbers.

You can also do this using a macro if you will be doing it often. If you
need help with the macro, post back.

HTH,
Bernie
MS Excel MVP
 
Top