Retrieve names to concatenate on one cell if meet certain criteria

I trying to do a formula on sheet 1 to retrieve the names that are on sheet 2 column C if sheet 2 column B=1 next to the name
i'am using this code from cpearson http://www.cpearson.com/excel/stringconcatenation.aspx to concatenate all names on one cell,
any help is greatly appreciated...thanks in advance....

Good afternoon score,

Would you mind attaching a workbook with a small sample of dummy data with an example of the before/after you're looking to accomplish so that we may better assist?

Thanks for your response Chenderson, dummy file attached, thank you very much...

I believe this UDF is perfectly in line with what you would like to accomplish :

Please Login or Register  to view this content.

Once you have this code in a module, the formula you use to concatenate your values will be as follows :

=concatenateif(Sheet2!B:B,1,Sheet2!C:C,CHAR(10))

Where the first range contains the placement, "1" is the criteria you would like to extract, the second range contains the values you would like concatenated, and the final section is an optional separator (in this case Char(10) is a line break). In order for the line breaks to show, please ensure you have "wrap text" enabled for the cell containing the formula.

The code above came from the following link :
https://www.extendoffice.com/documen...-criteria.html

Chenderson... It work perfect, thank you very very much!!!

Absolutely! I'm glad it works for you!