hi Brad.. I'm not one of the super-experts..but there is a very simple
formula that will also work, if you don't mind blank cells in your results
column. Assuming your data is in A1:B5, paste this in say, cell C2, and then
drag all the way down:

=IF(B$2:B$5="N",A$2:A$5,"")

You can then convert your results to values, and use the autofilter arrows
to filter in all your "nonblanks" - that way you get rid of all your blanks.

M

"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