Wonder if anyone can help. I run a football prediction league at work (10 games 3 points for a correct score 1 point if correct result) this will run for the season with a league running for person with most points my problem is i would like the league to auto update when i put results in. ive got as far as doing vlookup/hlookup but if two people have the same points it only shows the person with those points if two people have the same points then i would like the person with the most correct scores to be next in the league and if they are still the same then the person with the most correct results and if thats still the same then just alphabetical in order of name can someone point me in the right direction. Ive attached the full file if someone can help
thanks
Bookmarks