list name with same condition

[faeiz2]

Hi all, l have like this:

date 1 date 2 date 3
john dc nc
mary nc nc
peter dc of
carl of dc


I want to list in a cell names on a particular date with same value.
example for date 1

john and peter will appear in cell f3 like this john, peter,

tq

 

[JBeaucaire]

I think you need to use a new function called StringConcat. It's a
UserDefinedFunction written by C. Pearson. This site explains it:
http://www.cpearson.com/excel/stringconcatenation.aspx

Here is a sample workbook online where I used this function with an IF=
function, which is what you want to do
http://www.excelforum.com/attachmen...12-combine-number-in-one-row-stringconcat.xls

Hope that help.