01-22-2020, 10:09 PM | #1 | ||
Go Reds
Join Date: May 2001
Location: Bloodbuzz Ohio
|
Ping: Excel / Google Sheets Kings
I am doing a Super Bowl game for my business where I take 50 questions and accept the answers by a printable document and then a manual task of checking a box. I would then like to put everyones answers into an excel or sheets spreadsheet and have it calculate the total correct answers without me manually doing this by hand for 100+ documents. In other words, what is the easiest formula or link I can obtain to do such a task?
|
||
01-22-2020, 10:40 PM | #2 |
Death Herald
Join Date: Nov 2000
Location: Le stelle la notte sono grandi e luminose nel cuore profondo del Texas
|
might be easier to use Microsoft Access for that. Make a table for the people and answers then another table with the right responses then do a group by the respondent and the count of answers that match.
__________________
Thinkin' of a master plan 'Cuz ain't nuthin' but sweat inside my hand So I dig into my pocket, all my money is spent So I dig deeper but still comin' up with lint |
01-23-2020, 05:25 PM | #3 |
Go Reds
Join Date: May 2001
Location: Bloodbuzz Ohio
|
Haven't used Access in ages, but will take a look
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|