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?
|