| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combination searched
Does anyone know if it is possible to do combination searches with or without
ASAP utilities in Excel. For example, I have one column that is postal codes (V2X 3T7), and one that is names (Jack). I'm looking for a function that will allow me to search multiple sheets/tabs for Jack and V2X. Something like Jack*V2X that will give me all the "Jacks" with that postal prefix. Any suggestions? So far I have only been able to search these separately. Any help would be great! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
combination searched
By using AutoFilter you can set up separate criteria on each column and
display only those rows that match all criteria. -- Gary''s Student - gsnu200818 "Mark" wrote: Does anyone know if it is possible to do combination searches with or without ASAP utilities in Excel. For example, I have one column that is postal codes (V2X 3T7), and one that is names (Jack). I'm looking for a function that will allow me to search multiple sheets/tabs for Jack and V2X. Something like Jack*V2X that will give me all the "Jacks" with that postal prefix. Any suggestions? So far I have only been able to search these separately. Any help would be great! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wildcard characters, can they be used in tables to be searched? | Excel Worksheet Functions | |||
| Can a column of data be searched from bottom to top | Excel Worksheet Functions | |||
| VLOOKUP - returning the searched for value if it does not exist | Excel Discussion (Misc queries) | |||
| Additional Columns to be Searched | Excel Discussion (Misc queries) | |||
| VBA: Return Searched Value Inputed by End-User | Excel Worksheet Functions | |||
Linear Mode
