Hello.. I am not an Excel expert...but here's a very simple formula that will
return the names of those who have not replied. Assuming that your data is
in a1:b5, enter this into Col. C,

=IF(B$2:B$5="N",A$2:A$5,"") then drag down to bottom

(Translation: if any cell in column B range is N, then return corresponding
values in column A range, otherwise return a blank).

Of course, you'll have a bunch of blank cells, but you can always filter the
column where your results are (after you've transformed them to values), and
filter in all the non-blanks.

"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