In a third column, put the formula
=IF(B2 = "Y", A2 & ", " & C3, C3)
and copy it down for the entire column,
where column A is the vendors, column B is the qualified
and column C is the formula.

The cell to display the combined result could be
=LEFT(A2, LEN(A2) - 2)
to get rid of the trailing comma and space

Kevin Beckham

-----Original Message-----
Thank you in advance for your time and help.

Here is the senario:
I have a table with Vendor Names and Y or N next to each
name.

Vendor Name Qualified
A N
B Y
C Y
D N
E Y

I would like to concatenate all the Vendor Names that are
qualified in one cell. So for this example the result
would be: B, C, E

I realize that I need to write a formula to loop through
the data but I am not exactly sure how this is done. I
think I have a phobia of loops and arrays:)
.