Project Election Winner

[Monk]

Hi,

This could be easy or difficult. We are having an election with
choices. Suppose I sum columns A, B & C, use the result to project
winner. 362 people will vote in total.
What would my formula look like?

Mik

 

[Frank Kabel]

Hi
not really sure what you will have in those column A, B, C

But you may have a look at MAX or RANK for this

 

[Bob Phillips]

Hi Mike,

in column D

=IF(SUM(A1:C1)=MAX($A$1:$A$100+$B$1:$B$100+$C$1:$C$100),"Winner","")

which is an array formula, so commit with Ctl-Shift-Enter, and copy down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave R.]

It depends on what the data looks like. What numbers are in A,B,C? 1s and
0s?

If you are summing votes, why would you need to project?

 

[Monk]

Choices Option 1 Option 2 Option 3
362 Total Ballots 15 15 36
% of Total 4.1436% 4.1436% 9.9448%
Percent of Vote by Choice
22.7273% 22.7273% 54.5455%
Number of Votes 66
Percent of Voters Responding 18.2320%
Percent of Voters Remaining 81.7680%

Projected Winner ??????

Column e,f & g sum up the posted votes.
They happen to appear in row 365

So obviously some sort of logical formula using IF and MAX

Thanks so much
Mon

 

[Monk]

Thanks to all who responded. I suppose some sort of 'leaning' criteri
would be necessary to project a winner. This is a simple ballot with
choices and I went off on a tangent like it was some sort o
presidential election. It would be interesting to see what a formul
would look like that pictures the USA with each state divided int
percentage leaning, population etc.; start throwing in votes and le
the formula compute the winner.

Mik