Compiling Survey Results in Excel

Online course: Excel 365 for Busy People
www.udemy.com/...
Corporate training for Excel and other Microsoft and Adobe applications:
ComputerTrainin...
Between the Sheets, Episode 34: Compiling Survey Results in Excel
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.