find the winner name from highest numbers

M

mwvirk

New member
Joined
May 7, 2013
Messages
4
Reaction score
0
Points
0
Excel Version(s)
2016
[FONT=&quot]I need to ask another question here.[/FONT]

[FONT=&quot]since the highest number is resolved and also the runner-up. how can I take the names of the persons who got the highest and next to the highest person?[/FONT]

[FONT=&quot]I am splitting the sheet into 2 parts (i cannot install XL2BB on my office computer) sorry for this[/FONT]

[FONT=&quot]
A Row (merged cell A3 to A13) (values in this range is unique)B Row (merged cell B3 to B13) (values in this range is NOT unique)C Row (merged cell C3 to C13)D Row (merged cell D3 to D13) (values in this range is unique)E Row (merged cell E3 to E13)F Row (merged cell F3 to F13)G Row (merged cell G3 to G13)H Row (merged cell H3 to H13)I Row (merged cell I3 to I13)
NA # (2018)ProvinceNA # (2013)Seat NameRegistered VotersTotal Cast VotesRejected VotesValid Cast Votes% Of Total Registered Votes
NA-001Area-1NA-032

(Tribal Areas IV)

City-1		City-1318,150245,602500245,10277.20%





[/FONT]








[FONT=&quot]
J RowK RowL RowM RowN RowO RowP RowQ Row
Candidate NamePartyVotes% Of Candidate VotesWinner's NameWinner PartyRunner up NameRunner up Party
Candiate 001Party 1
18,000​​
7.34%
Candiate 002Party 2
50,000​​
20.40%
Candiate 003Party 3
19,000​​
7.75%
Candiate 004Party 4
20,000​​
8.16%
Candiate 005Party 5
50,001​​
20.40%
Candiate 006Party 6
16,100​​
6.57%
Candiate 007Independent
18,001​​
7.34%
Candiate 008Party 7
21,000​​
8.57%
Candiate 009Independent
8,000​​
3.26%
Candiate 010Independent
5,000​​
2.04%
Candiate 011Party 8
20,000​​
8.16%
[/FONT]


[FONT=&quot]
1652955898414-png.65024
[/FONT]



[FONT=&quot]
1652955936701-png.65025
[/FONT]


[FONT=&quot]
1652955957359-png.65026
[/FONT]
 

Attachments

  • test-0001.xlsx
    13 KB · Views: 2
In cell N3:
Code: 
=IF(L3=MAX($L$3:$L$13),J3,"")
O3:
Code: 
=IF(L3=MAX($L$3:$L$13),K3,"")
P3:
Code: 
=IF(L3=LARGE($L$3:$L$13,2),J3,"")
Q3:
Code: 
=IF(L3=LARGE($L$3:$L$13,2),K3,"")
All 4 cells copied down to row 13.
 
You must log in or register to reply here.
Back
Top