Ping: Excel / Google Sheets Kings

korme · 01-22-2020, 10:09 PM

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?

cartman · 01-22-2020, 10:40 PM

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.

korme · 01-23-2020, 05:25 PM

Haven't used Access in ages, but will take a look

01-22-2020, 10:40 PM	#2
cartman 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
korme 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)