|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 15th, 2009, 10:13 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
excel
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 
|
|
#2
February 15th, 2009, 10:44 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
Starting in A1, I have
Dora 12 Jack 15 Emma 10 The name of the winner is picked out by =INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3)) What do you want to happen if there is a draw for maximum? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Shone33" wrote in message ... 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
|
|
#3
February 15th, 2009, 10:46 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
"Shone33" wrote in message
... 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 You don't need a formula. Just enter the total votes for each candidate and do a sort... -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
|
#4
February 15th, 2009, 10:57 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
"Bernard Liengme" wrote in message
... Starting in A1, I have Dora 12 Jack 15 Emma 10 The name of the winner is picked out by =INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3)) Why complicate? Why not just sort and the winner is at the top? KISS!!!!! -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
|
#5
February 15th, 2009, 11:05 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
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
|
|
#6
February 15th, 2009, 11:33 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
I am just learning excel for accounting at work and we have to enter the
formula or function to determine the winner. the contestants are in columns b:e. My total votes are in column g. and i need to enter the winner by name in h. "Gordon" wrote: "Shone33" wrote in message ... 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 You don't need a formula. Just enter the total votes for each candidate and do a sort... -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s)
|
|
#7
February 15th, 2009, 11:35 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel
im fairly new to excel. my winners names are in columns b5:e5, the total
votes are in g5 and i have to put the winner by name in h5. "Bernard Liengme" wrote: Starting in A1, I have Dora 12 Jack 15 Emma 10 The name of the winner is picked out by =INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3)) What do you want to happen if there is a draw for maximum? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Shone33" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
