Compiling Yes/No Survey Results in Excel

#excelhacks #exceltutorials #excelforbeginners
If you have a survey with a list of yes/no questions, Excel can compile the answers of each respondent into a comma-separated list. Here’s how to do it using the IF, CONCATENATE and SUBSTITUTE functions together.

About Bob:
Bob Flisser has been a software trainer since the mid-1990s, specializing in Microsoft and Adobe suites. He has written and recorded video courses for LinkedIn Learning, Pluralsight, Skillsoft, Tuts+, and others, and is the co-author of a dozen books of tips and shortcuts for Microsoft applications. He has also written magazine articles and training manuals and set up corporate training centers.

Connect with Bob:

Learn more about Experts Exchange:

#excelforbeginners #excelhacks #exceltutorials