P
p cooper
Ive got some data
item blah MinSize Maxsize blah blah
1 26 32
2 18 24
3 20 26
4 28 33
350 28 30
I want to extract those results where eg 30 is between the minimum &
maximum
eg MinSize>29 or the MaxSize<31
if I put the on separate lines i get in an advanced filter i get
eg item 2 and 3 because the maxsize is <30
If i put the two statements on the same line it does and AND for each
record and i get nothing.
One way would be to do a sequential filter ( Max size <31 ) and then
from those filter again on a MinSize but id like to do it all in one (
macro easier)
Any way of doing an AND NOT
anyone any other ideas
item blah MinSize Maxsize blah blah
1 26 32
2 18 24
3 20 26
4 28 33
350 28 30
I want to extract those results where eg 30 is between the minimum &
maximum
eg MinSize>29 or the MaxSize<31
if I put the on separate lines i get in an advanced filter i get
eg item 2 and 3 because the maxsize is <30
If i put the two statements on the same line it does and AND for each
record and i get nothing.
One way would be to do a sequential filter ( Max size <31 ) and then
from those filter again on a MinSize but id like to do it all in one (
macro easier)
Any way of doing an AND NOT
anyone any other ideas