Front Office Football Central  

Go Back   Front Office Football Central > Main Forums > Off Topic
Register FAQ Members List Calendar Mark Forums Read Statistics

Reply
 
Thread Tools
Old 01-22-2020, 11:09 PM   #1
korme
Go Reds
 
Join Date: May 2001
Location: Dayton, OH
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?
__________________
"A common error: to have the strength of one's convictions. Rather, one should have the strength for an attack on their convictions."

Twitter

korme is offline   Reply With Quote
Old 01-22-2020, 11: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
cartman is offline   Reply With Quote
Old 01-23-2020, 06:25 PM   #3
korme
Go Reds
 
Join Date: May 2001
Location: Dayton, OH
Haven't used Access in ages, but will take a look
__________________
"A common error: to have the strength of one's convictions. Rather, one should have the strength for an attack on their convictions."

Twitter
korme is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -5. The time now is 08:56 AM.



Powered by vBulletin Version 3.6.0
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.