| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple results
Hi everybody,
How can I create a (new) sheet showing ALL results from a datasheet meeting a criteria(cell value), I tried INDEX/MATCH, but got only the first found, It should be possible somehow, But I have no clue Thanx in advance BTW: The datasheet is not sorted -- There are only 10 types of people in the world: Those who understand binary and those who don''''t. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple results
You are correct about MATCH and VLOOKUP usually finding only the first
occurance. The easiest thing to do is to use AutoFilter to display only the rows meeting your criteria. Then copy/paste the visible rows into a new sheet -- Gary''s Student - gsnu200728 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Calculate multiple results from multiple input values? | Excel Discussion (Misc queries) | |||
Linear Mode
