Filtering Numbers

  • Thread starter Thread starter Stewart Rothnie
  • Start date Start date
S

Stewart Rothnie

This is probably a very easy question to answer but I am
having great difficulty.
I simply want to filter a lot of data by numbers. For
example I have a lot of pressure data with readings every
second. I only want to use every hundredth point. If I try
autofilter - custom- ends with- it doesn't work. Only
works with text. None of the other number filters are of
use. Is it possible to filter by row number. For instance
to display every hundredth row? Any help would be
appreciated.
 
One way, in a helper column at the end of your data, put the following formula and then copy it
down as far as your data goes:-

=MOD(ROW(),100)=0

Selecet the data in this column and do Data / Filter Autofilter and then filter on TRUE

If you put 100 in say cell K1 and then make the formula:-

=MOD(ROW(),$K$1)=0

You can then easily change the value in K1 and change the intervals in the records you wish to
count
 
Back
Top