combination searched

M

Mark

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!
 
G

Gary''s Student

By using AutoFilter you can set up separate criteria on each column and
display only those rows that match all criteria.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
Creating a Search using a combo box and then creating a report. 4
Contains a Value Cell and Sumif? 4
Auto Merge text from multiple sources 0
Query to find a range of data 8
Combination of values targeting a result. 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
deconcatenate 4

Top