Hello all excel Guru I need your help...
Thanks in advance. I am new to excel. I know some formulas about numbers but do not know how to work with names. I have created a google FORM (for our group's general election) and send to all our group members via email for their vote. I am getting all the vote data (candidate's Name) via email from our member into google spreadsheet. My spreadsheet column's headings are as follows...
A/B/C.....O
Timestamp/President/Vise President/Secretary#1/Secretary # 2/Spfld Area Member#1/Spfld Area Member#2/Spfld Area Member # 3/Spfld Area Member # 4/St. Robert Area Member # 1/St. Robert Area Member # 2/St. Robert Area Member # 3/St. Robert Area Member # 4/Your First Name And Last Name/Your Email
Note:- This is not a big worksheet. There is no numeric value I will receive. The FORM I sent to our member is the same type as above with the fillable text box. Only they need to type the name of the person who they want to vote for each post. So I will receive only names of the candidate who they vote for into my above spreadsheet's rows.
How do I get the final result of the each post and ...
(1) How many Votes received for each post and candidate..
(2) How is the final winer for each post...
(3) Presentation Chart the final result...
Thanks again.....
Thanks in advance. I am new to excel. I know some formulas about numbers but do not know how to work with names. I have created a google FORM (for our group's general election) and send to all our group members via email for their vote. I am getting all the vote data (candidate's Name) via email from our member into google spreadsheet. My spreadsheet column's headings are as follows...
A/B/C.....O
Timestamp/President/Vise President/Secretary#1/Secretary # 2/Spfld Area Member#1/Spfld Area Member#2/Spfld Area Member # 3/Spfld Area Member # 4/St. Robert Area Member # 1/St. Robert Area Member # 2/St. Robert Area Member # 3/St. Robert Area Member # 4/Your First Name And Last Name/Your Email
Note:- This is not a big worksheet. There is no numeric value I will receive. The FORM I sent to our member is the same type as above with the fillable text box. Only they need to type the name of the person who they want to vote for each post. So I will receive only names of the candidate who they vote for into my above spreadsheet's rows.
How do I get the final result of the each post and ...
(1) How many Votes received for each post and candidate..
(2) How is the final winer for each post...
(3) Presentation Chart the final result...
Thanks again.....