Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofiltering for partial matches
My bank posts automatic payments for some accounts as follows:
123 PHONECOMPANY XXX 456 PHONECOMPANY XYZ I know how to autofilter for exact matches -- but it would be very helpful to autofilter for all the strings that have PHONECOMPANY inside them, whether or not they begin and/or end with different characters. Is there any way I can sort or filter for only the rows that have the string PHONECOMPANY, even if that's an internal string? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofiltering for partial matches
Click that filter arrow
choose custom choose contains type phonecompany Or choose custom choose equals type *phonecompany* PeterJordan wrote: My bank posts automatic payments for some accounts as follows: 123 PHONECOMPANY XXX 456 PHONECOMPANY XYZ I know how to autofilter for exact matches -- but it would be very helpful to autofilter for all the strings that have PHONECOMPANY inside them, whether or not they begin and/or end with different characters. Is there any way I can sort or filter for only the rows that have the string PHONECOMPANY, even if that's an internal string? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matches | Excel Discussion (Misc queries) | |||
matches in two collums of numbers? | Excel Discussion (Misc queries) | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
matches | Excel Discussion (Misc queries) | |||
counting matches | Excel Discussion (Misc queries) |