filtering

  • Thread starter Thread starter fideli
  • Start date Start date
F

fideli

Hi everyone,

I'm trying to filter a large amount of data. About 90000 points i
all. I've managed to grab every three full cycles, as it were, usin
=MOD(B5,3)>=2 as my filter criteria. However, I'd like to filter i
further. If I had the following situation:

42 6
43 6
45 6
21 -3
13 -3
5 -3
41 6
45 6
47 6
13 -3
4 -3
1 -3
etc..

where 6 points make a full "cycle". Is it possible to filter out th
maximum value for the first half of each cycle, and the minimum valu
for the other half, in order to have a table like this?

45 6
5 -3
47 6
1 -3
etc...

I believe that I could use the fact that the second column alway
switches from positive to negative in each cycle, but I'm still no
sure how to do so. If anyone can help, it would be great. If an
further clarification is needed, let me know and I'll add to this post
Thanks in advance!

fidel
 
Assuming the 6's and -3's are in column B, you could use
this in row 2 of a new column and fill down:

=OR(AND(B2=6,OR(B1=-3,B1<>6)),AND(B2=-3,OR(B3=6,B3<>-3)))

and now filter for TRUE on this column.

HTH
Jason
Atlanta, GA
 
thanks for the tip. it was really helpful. however, as a futur
reference, what if the maximum and minimum values were anywhere i
their respective sections? how would i use the MAX() and MIN(
functions effectively
 
Back
Top