Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I search by more than one criteria in excel?
I have a spread sheet that has various fields like name of person taking
call, name of person calling in, their account number, their order number etc. I would like to be able to have a search function in Excel to look up by more than one of these criteria, like order number and name of person calling in - or any combination I might want without being case specific. I would like to pull up as many possiblilties as possible but limited to the criteria put in to search by. |
#2
|
|||
|
|||
"vulcan88" wrote in message ... I have a spread sheet that has various fields like name of person taking call, name of person calling in, their account number, their order number etc. I would like to be able to have a search function in Excel to look up by more than one of these criteria, like order number and name of person calling in - or any combination I might want without being case specific. I would like to pull up as many possiblilties as possible but limited to the criteria put in to search by. It seems you need to define these fields as a database. /Fredrik |
#3
|
|||
|
|||
I think Microsoft designed the AutoFilter to do exactly
what you're looking for. Debra Dalgleish has a nice tutorial on her website that'll get you started: http://www.contextures.com/xlautofilter01.html HTH Jason Atlanta, GA -----Original Message----- I have a spread sheet that has various fields like name of person taking call, name of person calling in, their account number, their order number etc. I would like to be able to have a search function in Excel to look up by more than one of these criteria, like order number and name of person calling in - or any combination I might want without being case specific. I would like to pull up as many possiblilties as possible but limited to the criteria put in to search by. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
How do I set up Excel to search nearest resource by address | Excel Worksheet Functions | |||
How do I search for an asterisk in an Excel file--it thinks the a. | Excel Discussion (Misc queries) | |||
Excel - Formula Query: Search for and Return Value | Excel Worksheet Functions |