| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to search a value with two criteria from a database?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to search a value with two criteria from a database?
Search for the least likely value. Then for each one found, check for the
second value in the same row. See help for the FindNext command in Excel VBA help to see an example. Specify values for all arguments for the find method in your command (unlike the example) to ensure consistent behavior. -- Regards, Tom Ogilvy "alex lee" <alex wrote in message ... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to search a value with two criteria from a database?
An alternate approach is to apply an Autofilter or and Advanced filter.
-- Regards, Tom Ogilvy "alex lee" <alex wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for database search - is it possible? | Excel Discussion (Misc queries) | |||
| Search number within a database | Excel Worksheet Functions | |||
| =DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
| Database Search For Help? | Excel Discussion (Misc queries) | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Linear Mode
