Between the Sheets — Excel podcast episode 33: Compiling Yes/No Survey Results in Excel

In partnership with Experts Exchange.

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.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Excel 365 for Busy People

Are you short on time and need to learn or brush up on intermediate and advanced Excel? Check out my course, “Excel 365 for Busy

Get in touch