Hi, normally when I run a golf competition the result is decided by whosoever has the highest points. However, on rare occasions we play a "medal" which actually means that the lowest score wins. In the attached workbook on the "Results" worksheet I have a competition called Cambridgeshire. The result is now the wrong way round, so the highest score is 1st when I need it to be the lowest score shown in column D. I'm guessing the very first segment of the formula in Column J needs to be altered but I don't know how. Any help much appreciated.
Bookmarks