You can use the formulas to return the data then a second formula to
concatenate, assume the result are in B1:B4 then you can use

=B1&" "&B2&" "&B3&" "&B4

to put the result in one cell


--

Regards,

Peo Sjoblom

"jackie" wrote in message
...
Brad-

I am trying to do something similar and need my data to appear in one cell
also. If you figure out how to get the output in one cell only, please
reply.

Thanks.

"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