Hi all,

In column A, I have a list of peoples names.
In cell "B1", I have a Drop down list with the options "Yes" and "No".

If "Yes" is selected in the drop down, I want "C2" to be populated with all the names in Column A, separated by a comma.

This list of names in column A is variable in number, so a straight forward IF statement did not work.

I have named the range in column a as "Names" using the following formula:
=OFFSET(Book1!$A$2, 0, 0, COUNTA(Book1!$A:$A)-1,1)

How can I use "Names" to populate "C2"?

Thanks!!