=INDEX($A$1:$A$4,SMALL(IF($B$1:$B$4="N",ROW(B1:B4) ),ROW(1:1)))
array entered
assuming A1to a4 is your cells holding the names and b1:b4 holds the replies

Copy this formula all the way down till you encounter a #NUM! error
or ask it within a If(isserror(ind... to get rid of the errors too




"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