| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array formulas and index lookup
Ive got some data starting in A1
A B C D E F G H D N O N O D D D ie shift workers ={(B1:B8="N")} gives me an array of true/falses Id like an array that returns the names of those who match the criteria ie {B, D) I can do it with a series of individual INDEX( MATCH ...) formulae can i do it with an array formula? can it be done with a oneliner? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use array for lookup value, to return array of lookups | Excel Discussion (Misc queries) | |||
| Lookup/Array Formulas | Excel Worksheet Functions | |||
| table, index, array, match, lookup? | Excel Worksheet Functions | |||
| V-Lookup, column index number indicator in table array | Excel Worksheet Functions | |||
| Index/ Lookup formulas and fuzzy matching | Excel Worksheet Functions | |||
Threaded Mode
