| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
thank you it works perfectly!!!!
"Walt" wrote: Hi raph_baril, This is from the Excel 2002 help system: "More than two sets of conditions for one column To find rows that meet greater than two sets of conditions, include multiple columns with the same column heading. For example, the following criteria range displays sales that are between 5,000 and 8,000 in addition to sales that are less than 500. Sales Sales 5000 <8000 <500 " You can repeat the field names within the criteria. Think of columns as "and" and rows as "or" criteria. Best Regards, Walt Weber "raph_baril" wrote: Hi, I'm trying to do an advanced filter with 3 criterias 1 "begins with A" 2 "does not begins with B" 3 "contains c" The problem is that I can only one of each at a time for e.g. my criteria looks like: "Name of column" ="=A*" So the advanced filter shows me all data beginning with A in this column, but I how can use all 3 criterias at the same time? Thank you |
Threaded Mode
