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

for every cell search identical in range, not whole column; how? 2
PowerPoint Super Stuck and Desperately Need Help 0
Update Query Help 2
Most Common Name In Column Using Cell formular 1
Sum on multiple columns with search criteria 6
Arranging data in a spreadsheet 1
Problem getting Excel formula to Calculate 2
help with a query 5

Top