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

Experts Exchange Adobe Expert (me)

Experts Exchange named me as the leading expert for Adobe Creative Suite. Check out my tutorial on the new artificial intelligence features in Photoshop.

Get in touch