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
 
You must log in or register to reply here.

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

Similar Threads

filter a list of numbers 5
Auto-filter selection 1
Numbering Rows in Filtered Data - Excel 2002 3
Filter is slow 1
Macro Help 6
SUBTOTAL not refreshing when using advanced filter 2
Filtering without redundancies 2
Auto filter for multiple columns 2

Back
Top