| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
