Assumptions:

A1:B4 contains your data

C1 contains your criteria, such as 'N'

Formula:

D1, copied down:

=IF(ROWS($D$1:D1)<=COUNTIF($B$1:$B$4,$C$1),INDEX(A $1:A$4,SMALL(IF($B$1:$B
$4=$C$1,ROW($B$1:$B$4)-ROW($B$1)+1),ROWS($D$1:D1))),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Brad" wrote:

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