Select 4 cells, array enter this formula in all 4 cells

=IF(ISERROR(SMALL(IF(B2:B5="Y",ROW(B2:B5),""),ROW( 1:4))),"",INDEX(A1:A5,SMAL
L(IF(B2:B5="Y",ROW(B2:B5),""),ROW(1:4))))

note that index starts from row 1, I find that easier to understand than to
have to offset the result because you would want to use A2:A5


--

Regards,

Peo Sjoblom

"Brad" wrote in message
...
Thanks for taking the time to read my question.

I am just learning how to use Array formulas in Excel. I can Sum, Count
etc. I am wondering if you can return an array of data with an array
formula

Example:

Name Replied?

Bob N
Brian Y
Robyn N
Rachel Y

From the table above if I test for "N" I'd like the formula to return a
list
of names, in this case Bob and Robyn.

Thanks again for your help,

Brad