Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Wildcards
All, everyday at work I pull a spreadsheet with over 1000 orders that
are worked by me and 2 other ppl. I have a column on the spreadsheet that lists the order numbers (7 numerical characters). The three ppl in my department divide the orders based on the last 2 digits of the orders; 1st person = 00-33, 2nd person 34-66... etc. My questions is: What is the easiest way to automate filtering only my orders and copying them into a new file? I tried the Auto-Filter mode and tried using wildcards (* and ?) to replaced the first 5 numerical characters of the order, but nothing happened. Please assist. I'm using Excel 2003. Thanks! Javier Cortes |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Wildcards
Use Advanced Filter instead Auto Filter. To filter orders with 00-33 use
*00-33* tim "soke2001" wrote: All, everyday at work I pull a spreadsheet with over 1000 orders that are worked by me and 2 other ppl. I have a column on the spreadsheet that lists the order numbers (7 numerical characters). The three ppl in my department divide the orders based on the last 2 digits of the orders; 1st person = 00-33, 2nd person 34-66... etc. My questions is: What is the easiest way to automate filtering only my orders and copying them into a new file? I tried the Auto-Filter mode and tried using wildcards (* and ?) to replaced the first 5 numerical characters of the order, but nothing happened. Please assist. I'm using Excel 2003. Thanks! Javier Cortes |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Wildcards
For more details about using the Advanced Filter go to this address:
http://www.contextures.com/xladvfilter01.html and download the example workbook. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - Wildcards
If you use a help column with formulas extracting everything but the first 5
characters you could use autofilter and maybe also under custom begins with or end with help formula to remove the first 5 characters =MID(A2,6,255) copy down then you can filter on the help column -- Regards, Peo Sjoblom "soke2001" wrote in message oups.com... All, everyday at work I pull a spreadsheet with over 1000 orders that are worked by me and 2 other ppl. I have a column on the spreadsheet that lists the order numbers (7 numerical characters). The three ppl in my department divide the orders based on the last 2 digits of the orders; 1st person = 00-33, 2nd person 34-66... etc. My questions is: What is the easiest way to automate filtering only my orders and copying them into a new file? I tried the Auto-Filter mode and tried using wildcards (* and ?) to replaced the first 5 numerical characters of the order, but nothing happened. Please assist. I'm using Excel 2003. Thanks! Javier Cortes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcards and if | Excel Worksheet Functions | |||
Excel custom autofilter- how to find wildcard characters but not as wildcards (e.g. "?") in a cell | Excel Discussion (Misc queries) | |||
use of wildcards | Excel Worksheet Functions | |||
Can wildcards be used in the Logic Test of an Excel "IF" function? | Excel Worksheet Functions | |||
How can I find strings of wildcards in Excel? | Excel Discussion (Misc queries) |