farmgirl1718
New Member
- Joined
- Jul 8, 2013
- Messages
- 8
Hi! I am so relieved to learn about the forum. I am a first time poster with my challenge below. I am appreciative for any and all help or guidance that you can provide.
I am trying to build a new report using database outputs. On the new report tab that I am creating, I created a dropdown list with survey name options, which I am trying to link to the information in the database output tab to show number of answers per option in the dropdown list.
The problem is, the countif and vlookup options are not correctly showing this information for one candidate or calculating based on the option referenced in the dropdown menu, because there is more than one option in the database output list. When using the countif or vlookup, I am having trouble with it calculating the match.
Please see my example below:
Database Output
Name, Answer 1
Candidate1, 4
Candidate1, 4
Candidate1, 2
Candidate1, 1
Candidate2, 3
Candidate2, 5
Candidate2, 3
New Report Tab
Summary, Answer 1 Criteria (1, 2, 3, 4, 5)
Candidate1, (1, 1, 0, 2, 0) (<=This is what I am trying to summarize from the database output per question per candidate.)
Thank you so much for all of your help!
I am trying to build a new report using database outputs. On the new report tab that I am creating, I created a dropdown list with survey name options, which I am trying to link to the information in the database output tab to show number of answers per option in the dropdown list.
The problem is, the countif and vlookup options are not correctly showing this information for one candidate or calculating based on the option referenced in the dropdown menu, because there is more than one option in the database output list. When using the countif or vlookup, I am having trouble with it calculating the match.
Please see my example below:
Database Output
Name, Answer 1
Candidate1, 4
Candidate1, 4
Candidate1, 2
Candidate1, 1
Candidate2, 3
Candidate2, 5
Candidate2, 3
New Report Tab
Summary, Answer 1 Criteria (1, 2, 3, 4, 5)
Candidate1, (1, 1, 0, 2, 0) (<=This is what I am trying to summarize from the database output per question per candidate.)
Thank you so much for all of your help!
Last edited: