I am running a prediction competition at work depending on the results from various football games. I have a table that gives everybodys score and I rank them all depending on the points they score.
If there is a tie on points scored then we see who picked the least number of home wins. I have all of this data in a data table but I want to see it on the results table in a different tab.
The problem I have is currently I have labelled them as Winner and a number depending on their rank and use the vlookup function to return Winner 1, Winner 2 etc. The problem is that when there are two Winner 1s ( a tie) it only returns 1 of the Winner 1s. Is there a better wat to report the two people if there are two winners
If there is a tie on points scored then we see who picked the least number of home wins. I have all of this data in a data table but I want to see it on the results table in a different tab.
The problem I have is currently I have labelled them as Winner and a number depending on their rank and use the vlookup function to return Winner 1, Winner 2 etc. The problem is that when there are two Winner 1s ( a tie) it only returns 1 of the Winner 1s. Is there a better wat to report the two people if there are two winners
