Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FILTERING DATA VALUES
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 filteradvanced 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 "JURBOP" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filtering data to include values only if x and y exist | Excel Discussion (Misc queries) | |||
Filtering out single values (keeping only repeating data) | Excel Discussion (Misc queries) | |||
Filtering diverse values | Excel Worksheet Functions | |||
filtering on range of values | Excel Discussion (Misc queries) | |||
Filtering and replacing values through a macro | Excel Worksheet Functions |