I have a spreadsheet with precincts, candidates and the number of votes each received. I have used an Index/Match/Max string to determine which candidate received the most votes. But this does not work if two or more candidates received the same number of votes. I need to either 1. Check for ties/same values after running my Index/Match/Max string or 2. I need a formula which will show me the max of the cells or if there is a tie. So I have two questions. Is there a way to accomplish number 2, and what's the best way to check for ties among multiple cells?
Attached is an example. the winner column shows the candidate with the max votes. But, if you look at row 5, Candidate 1 and 2 have the same number of votes. So ideally, my formula would return False because there is no real max. A separate formula that would check for ties would also work. Thanks.
Attached is an example. the winner column shows the candidate with the max votes. But, if you look at row 5, Candidate 1 and 2 have the same number of votes. So ideally, my formula would return False because there is no real max. A separate formula that would check for ties would also work. Thanks.