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/attachment...ringconcat.xls

Hope that help.
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"faeiz2" wrote:

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