FILTERING DATA VALUES

[JURBOP]

Hi;
I'm having problems filtering data based on the values in a column, I can't
seem to get the formula syntax correct. I've given a column of numeric values
a RANGE name and I'm trying to select the numeric values between 2 other
values (eg. >= 25 AND <= 95). Can I filter out those values in a column and
if TRUE copy that row of data to another spreadsheet? If not, can I at least
copy the column to another spreadsheet, or even a blank column in the same
spreadsheet? I've tried using the BETWEEN operator and I've tried using the
logic operators < and > but keep getting syntax error messages I haven't been
able to resolve. Please help. Thanks.

 

[Peo Sjoblom]

I am assuming you mean advanced filter, you might want to use autofilter,
select custom and then greater than or equals to 25 AND less than or equal
to 95.


Of course the advanced filter is more powerful, make sure you have a header,
let's say the header is called "Header" and your range is named "MyRange"


you need an AND criteria, assume it starts in F1, so in F1 and G1 put Header
(you need to use it twice since you want an AND condition.)

In F2 put >=25 in G2 put <=95

now select the range, do filter>advanced filer and in the list range put
MyRange, in the criteria range put $F$1:$G$2 and click OK

replace Header and MyRange with the actual names you are using



--


Regards,


Peo Sjoblom