| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Obtaining Multiple Results Using Index/Match Functions
How about Auto Filter
"Archie999" wrote: I have a small table similar to the following: Color Object A B 1 Green Apple 2 Yellow Banana 3 Red Stop Sign 4 Green Grass =INDEX(A1:B4,MATCH("Green",A1:A4,0),2) -- (Apple) INDEX/MATCH formula works perfectly to obtain the first matching record, but how can I create a list (each matching item in its own cell in a column) of all matching records, ie all objects that are Green. Is there some sort of Exclude function that will allow me to use the same formula without producing the same result as the cell above it? A Pivot Table is overkill for what I am trying to do. -- Archie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
| Index and Match results | Excel Worksheet Functions | |||
| Index and Match Functions | Excel Worksheet Functions | |||
| Help Please - Match & Index Functions (I hope)! | Excel Discussion (Misc queries) | |||
| How do I use the Match and Index functions to look up a value tha. | Excel Worksheet Functions | |||
Linear Mode
