M
Mr . .
I have thirteen different surveys with multiple questions. Three of the Q's
are the same for each survey. I need to bring the answers from the 3Q's
together in one table and then provide one overall graph.
PLAN:
I created 15 worksheets, one for the graph, one for the overall data
summary, and 13 extras (one for each set of exported/imported survey data.)
The survey application allows me to extract the results in text form, yet I
need numbers for the totals & graphs.
On the summary sheet for SUP Table in a cell by row Q1 and column A1 (answer
1) I'd like to count the number of times a specific word shows up in one of
the columns on the SUP survey results sheet and then put the resulting # in
the cell on the SUP table of the summary sheet. I'd do this for each of the
3q's and each of the possible answers, for each of the 13 different survey
tables. This would bring the #'s of each response to the front sheet. (I
could graph each of the 13 tables as well.)
Once that is done, I'd go up to the overall section table LOGISTICS and do
some counting of the data in each cell of the thirteen sub tables, to bring
a total for the LOGISTICS survey's all in one table, which I can then graph.
STATUS:
I created all the tabs, and tables.
I started with the SUP survey results, and a "countif" function, but the
function is not counting the text string data that I put in the function.
I'd like to try to convert the text string to a specific number and then do
a "count if" for the # and have that total be put in the cell.
So I'd be trying to do two functions... first convert and then countif. Can
that be done?
Sample file attached, if not I can send it to somewhat who requests it at:
(e-mail address removed)
I'm also hoping to get the date field (date the person submitted their
survey response) extractd from the survey program in the near future. I'd
then like to add another function to the two above for each of the cells.
so that the conversion would happen, and the count if would happen based on
a certain date range, & the results from those three functions would be the
data for one Qtr in the fiscal year. The funtions would help to sum the
data from each survey and put the totals in the rows and columns for each
quarter.
Anyone have some suggestions?
Mr.
are the same for each survey. I need to bring the answers from the 3Q's
together in one table and then provide one overall graph.
PLAN:
I created 15 worksheets, one for the graph, one for the overall data
summary, and 13 extras (one for each set of exported/imported survey data.)
The survey application allows me to extract the results in text form, yet I
need numbers for the totals & graphs.
On the summary sheet for SUP Table in a cell by row Q1 and column A1 (answer
1) I'd like to count the number of times a specific word shows up in one of
the columns on the SUP survey results sheet and then put the resulting # in
the cell on the SUP table of the summary sheet. I'd do this for each of the
3q's and each of the possible answers, for each of the 13 different survey
tables. This would bring the #'s of each response to the front sheet. (I
could graph each of the 13 tables as well.)
Once that is done, I'd go up to the overall section table LOGISTICS and do
some counting of the data in each cell of the thirteen sub tables, to bring
a total for the LOGISTICS survey's all in one table, which I can then graph.
STATUS:
I created all the tabs, and tables.
I started with the SUP survey results, and a "countif" function, but the
function is not counting the text string data that I put in the function.
I'd like to try to convert the text string to a specific number and then do
a "count if" for the # and have that total be put in the cell.
So I'd be trying to do two functions... first convert and then countif. Can
that be done?
Sample file attached, if not I can send it to somewhat who requests it at:
(e-mail address removed)
I'm also hoping to get the date field (date the person submitted their
survey response) extractd from the survey program in the near future. I'd
then like to add another function to the two above for each of the cells.
so that the conversion would happen, and the count if would happen based on
a certain date range, & the results from those three functions would be the
data for one Qtr in the fiscal year. The funtions would help to sum the
data from each survey and put the totals in the rows and columns for each
quarter.
Anyone have some suggestions?
Mr.