Compiling Yes/No Survey Results in Excel
4.1 هزار بار بازدید -
2 سال پیش
-
#excelhacks
#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:
Experts Exchange: https://www.experts-exchange.com/memb...
LinkedIn: LinkedIn: bobflisser
Learn more about Experts Exchange:
Info: https://go.experts-exchange.com/
Try free for 7 days: https://go.experts-exchange.com/pricing
#excelforbeginners #excelhacks #exceltutorials
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:
Experts Exchange: https://www.experts-exchange.com/memb...
LinkedIn: LinkedIn: bobflisser
Learn more about Experts Exchange:
Info: https://go.experts-exchange.com/
Try free for 7 days: https://go.experts-exchange.com/pricing
#excelforbeginners #excelhacks #exceltutorials
2 سال پیش
در تاریخ 1401/12/02 منتشر شده
است.
4,120
بـار بازدید شده