I have a Google form that was used for award votes and nominations. Specifically, each question contained drop-down value and the voters each selected an option from the list. At the end of the form, they were prompted to enter their email addresses.
Google Forms provides a wonderful pie chart summary of which selections had the highest entries. However, some voters voted twice. I removed the duplicate entries from the associated Google Sheets document, however, it did not update the tallies from within the Google Forms view of the voter questionnaire.
What is the proper way to strip duplicates, based off of a given criteria and update the form results?