Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
survey results tally
We have sent a survey form to our customers and I'd like to use Excel to
tally the results. I've made a sheet listing all the questions and possible answers. I'm wondering if anyone can advise the best way to have an employee go into the sheet and add another mark to the chosen response as the surveys are returned? I'm picturing him just clicking on the cell that represents the chosen check box for each answer and a formula counting those clicks, but I'm not seeing any possible way to work that... is it possible? Thanks for any guidance - thought I'd ask here before creating something cumbersome! Mary |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
survey results tally
Have you considered using Data Validation as a way of "collecting" your
responses rather than check boxes? "ME Hill" wrote: We have sent a survey form to our customers and I'd like to use Excel to tally the results. I've made a sheet listing all the questions and possible answers. I'm wondering if anyone can advise the best way to have an employee go into the sheet and add another mark to the chosen response as the surveys are returned? I'm picturing him just clicking on the cell that represents the chosen check box for each answer and a formula counting those clicks, but I'm not seeing any possible way to work that... is it possible? Thanks for any guidance - thought I'd ask here before creating something cumbersome! Mary |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
survey results tally
"Toppers" wrote in message ... Have you considered using Data Validation as a way of "collecting" your responses rather than check boxes? "ME Hill" wrote: We have sent a survey form to our customers and I'd like to use Excel to tally the results. I've made a sheet listing all the questions and possible answers. I'm wondering if anyone can advise the best way to have an employee go into the sheet and add another mark to the chosen response as the surveys are returned? I'm picturing him just clicking on the cell that represents the chosen check box for each answer and a formula counting those clicks, but I'm not seeing any possible way to work that... is it possible? Thanks for any guidance - thought I'd ask here before creating something cumbersome! Mary It's not an online survey - sorry, guess I should have mentioned ;) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
survey results tally
If you ONLY want a tally, then you are going to have to have VBA code to do
the accumulation whether or not you use check boxes or another method. If individual responses are recorded, then formulae could be used to produce the required tallies. If a wrong check box is ticked you have to undo it and then tally the correct one: this appears to me to be a "risky" approach. The main disdavantange of doing an overall tally is that you will not be able to do "what if" analysis on your data i.e look at permutations of answers (which of course may not be required). You (probably) will need some sort of trigger e.g. a button, to indicate the data has been entered and therefore the accumulation should be actioned. HTH "ME Hill" wrote: We have sent a survey form to our customers and I'd like to use Excel to tally the results. I've made a sheet listing all the questions and possible answers. I'm wondering if anyone can advise the best way to have an employee go into the sheet and add another mark to the chosen response as the surveys are returned? I'm picturing him just clicking on the cell that represents the chosen check box for each answer and a formula counting those clicks, but I'm not seeing any possible way to work that... is it possible? Thanks for any guidance - thought I'd ask here before creating something cumbersome! Mary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on pivot table results = #N/A | Excel Worksheet Functions | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
calculating results in formulas | Excel Discussion (Misc queries) | |||
Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) | |||
Tabulating Survey Results | Excel Discussion (Misc queries) |