View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JURBOP JURBOP is offline
external usenet poster
 
Posts: 2
Default FILTERING DATA VALUES

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.