You can’t make document adjustments more convenient than editing your spreadsheet files online. With DocHub, you can get instruments to edit documents in fillable PDF, spreadsheet, or other formats: highlight, blackout, or erase document elements. Add textual content and pictures where you need them, rewrite your form completely, and more. You can download your edited file to your device or submit it by email or direct link. You can also convert your documents into fillable forms and ask others to complete them. DocHub even provides an eSignature that allows you to certify and send documents for signing with just a couple of clicks.
Your records are safely stored in our DocHub cloud, so you can access them at any time from your desktop computer, laptop, mobile, or tablet. If you prefer to use your mobile phone for file editing, you can easily do so with DocHub’s app for iOS or Android.
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