Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multi conditional searching
Guys,
please help me! I struggle with some problem: I have a list: date no code 12/4/6 101 AA 12/4/6 101 AB 12/4/6 102 AA 12/4/6 102 AA 12/4/6 102 AA 13/4/6 101 AA 13/4/6 101 AC 13/4/6 101 AB 13/4/6 102 AA .... .... I'm trying to generate a list of codes matching to criteria, e.g.: date no 13/4/6 101 Unfortunately function 'MATCH' can find a record using just one criteria, and 'DGET' returns #NUM if there's more then one record matching the criteria. What I need to get is: AA AC AB e.g. as array. Or if it's not possible at least first of the matching. Is there any way to do it? Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |