[FONT="]I need to ask another question here.[/FONT]
[FONT="]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="]I am splitting the sheet into 2 parts (i cannot install XL2BB on my office computer) sorry for this[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]
[/FONT]
[FONT="]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="]I am splitting the sheet into 2 parts (i cannot install XL2BB on my office computer) sorry for this[/FONT]
[FONT="]
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) | Province | NA # (2013) | Seat Name | Registered Voters | Total Cast Votes | Rejected Votes | Valid Cast Votes | % Of Total Registered Votes |
NA-001 | Area-1 | NA-032 (Tribal Areas IV) City-1 | City-1 | 318,150 | 245,602 | 500 | 245,102 | 77.20% |
[FONT="]
J Row | K Row | L Row | M Row | N Row | O Row | P Row | Q Row |
Candidate Name | Party | Votes | % Of Candidate Votes | Winner's Name | Winner Party | Runner up Name | Runner up Party |
Candiate 001 | Party 1 | 18,000 | 7.34% | ||||
Candiate 002 | Party 2 | 50,000 | 20.40% | ||||
Candiate 003 | Party 3 | 19,000 | 7.75% | ||||
Candiate 004 | Party 4 | 20,000 | 8.16% | ||||
Candiate 005 | Party 5 | 50,001 | 20.40% | ||||
Candiate 006 | Party 6 | 16,100 | 6.57% | ||||
Candiate 007 | Independent | 18,001 | 7.34% | ||||
Candiate 008 | Party 7 | 21,000 | 8.57% | ||||
Candiate 009 | Independent | 8,000 | 3.26% | ||||
Candiate 010 | Independent | 5,000 | 2.04% | ||||
Candiate 011 | Party 8 | 20,000 | 8.16% |
[FONT="]
[FONT="]
[FONT="]