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.