| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advanced Filter by Cell Formatting
Hi groupies
Is it possible to use an Advanced Filter to filter cells by their formatting. For example. If I have a list of customers, some from the States some from Canada and some from Europe, I would like to be able to filter by the format of the data in the PostalCode/ZipCode field. Canadian Postal Codes are L9L 9L9 format, US being 99999-9999 etc. Any ideas? -- Thanks for the brainwaves! CJ I blame the parents........ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
| Advanced formatting operation on a cell | Excel Discussion (Misc queries) | |||
| advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Threaded Mode
