![]() |
![]() |
#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?
|
||
![]() |
![]() |
![]() |
#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 |
![]() |
![]() |
![]() |
#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 | |
|
|