I Have a list of names that are a result of a golf competition, they are divided into 2 columns, one their Gross score & their Nett score.
What I want to do is determine the winner of the Nett competition, a person can only claim one trophy so this is where it gets complicated.
In list 1 the Gross winner could also be the Nett winner but as they can only claim 1 trophy they will take the Gross Trophy.
this is what should happen, IF H8=E8,E9,H8 and so on so that if the same name appears in the same position on both lists then the next name is elevated.
Hope that someone can understand this and help? :?