Suppose your candidate's name are in column A and number of votes are in
column B. Put this function in C1 to get the candidate name with max vote
=OFFSET(B1,MATCH(MAX(B1:B100),B1:B100,0)-1,-1,1,1)
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Shone33" wrote:

how can I create a formula that will let me determine who will be a winner in
a elections. I already have the each individual votes and total votes, but I
need a formula to input the winner