Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
i want to try this again. I am trying to determine a winner for each county.
In b5:e5 I have my canidates. In column A6:a139 i have my counties, B6:E6 i have the votes for each canidate. in G6 i have my total votes, and in H6 i need to input the winner by name using a formula. I tried =index(b5;e5,match(max(b6:e6),B6:e6)) that gave me the person with the least votes and i need the highest votes. Please tell me what am i doing wrong. I am on windows vista home premium, excel 2007, service pack 1 thanks Shone |