Formular is comparing the adjacent cell when it shouldn't be?
I am trying to keep track of some scores from games and trying to keep track of who is the highest scoring player, most kill and most knocks.
I asked for help on here before and someone very kindly helped with a formular that worked perfectly for highest damage and most kills until I added a new column for the knocks.
So if the score is equal it should show "non" however since adding the column it now does this as it compares to the other cells.
For example in the picture in O5 I want it to compare cells F5 and I5 and show the name player two as that player has the highest unique score. However it takes H5 into consideration and sees it as a draw returning a "non" for the name.
Here are the forumlars I have used.
m5 =IF(COUNTIF(G5:J5,MAX(G5,J5))>1,"non",INDEX(E$4:K$4,MATCH(MAX(G5,J5),G5:J5,0)))
o5 =IF(COUNTIF(F5:I5,MAX(F5,I5))>1,"non",INDEX(E$4:K$4,MATCH(MAX(I5,F5),F5:I5,0)))
q =IF(COUNTIF(E5:J5,MAX(E5,H5))>2,"non",INDEX(E$4:K$4,MATCH(MAX(E5,H5),E5:H5,0)))
I'm sorry if it is a bit rambling, I am not the best at expressing what I am trying to say. I have attached an image which will hopefully help.
