Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract multiple results based on multiple criteria
Hi,
I've got a spreadsheet with data exported for a project plan. In order to create some Excel charts I need to extract dates based on multiple criteria. Unfortunately, in some cases the criteria are not unique and I need all the results. I'm unsing INDEX and MATCH to get my data but I can't figure out how to convert into something where I can get the multiple results. I'm getting data from sheet Task_Table1 where column D is the part number and column E is the task. For some part numbers there are occasionally repeated tasks The following array formula gives me the date I need to extract for the first match for each item in my list part numbers on worksheet Data =INDEX(Task_Table1!$K$2:$K$500,MATCH(Data!$A4,IF(T ask_Table1!$E$2:$E$500=$B$1,Task_Table1!$D$2:$D$50 0),0)) Is there a way to modify this such that if my list of part numbers (repeating the part number if two of the particular tasks are expected) can have the required dates listed in another column? The formula can display an error or NA if there's no result. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Results based on multiple criteria | Excel Discussion (Misc queries) | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Multiple results in 1 cell w/ multiple criteria | Excel Worksheet Functions | |||
Multiple criteria with multiple results in one cell | Excel Worksheet Functions | |||
Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) |