Editing excel is fast and straightforward using DocHub. Skip downloading software to your laptop or computer and make changes using our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its efficiency and robust features that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and send documents for completion to other people. All of this, combined with a competing price, makes DocHub the perfect decision to rework questionaire in excel files with ease.
Make your next tasks even easier by turning your documents into reusable templates. Don't worry about the safety of your data, as we securely store them in the DocHub cloud.
hi Iamp;#39;m Bob and welcome to Between the Sheets where we look at Microsoft Excel and related Technologies if you have a list of yes no survey questions Excel will do a good job of compiling the results but it isnamp;#39;t obvious or straightforward hereamp;#39;s a solution I found that does a good job using the if concatenate and substitute functions so letamp;#39;s take a look see how it works here are simplified results of what a survey might show you we want the last column to show a comma separated list of which flavors each person likes so it will be like chocolate comma vanilla and so on letamp;#39;s build this piece by piece now you see the first flavor here is chocolate and what we can do is use the IF function to say that if there is an X in the First Column there and that chocolate column then grab that name from the column header and we put it there in column A now Iamp;#39;ve already done an episode on the IF function so I wonamp;#39;t go through the syntax again
