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!!
Bookmarks