Golf Tie Breaker Excel VBA Code

完了済み 投稿 5年前 着払い
完了済み 着払い

I run a golf tournament each year and use Excel to add scores and conditional formatting to identify the winners. Unfortunately there are several teams that always tie and it's difficult to quickly determine the tie break using the standard golf method which is: starting with the most difficult hole, compare scores and lowest score wins the tie break. If that hole is tied you move to the second most difficult hole and so on. In the attached example, team 1 and 6 are tied for first but conditional formatting shows them both in second (yellow). You need to compare scores and go to the 3rd most difficult hole before you find that team 1 wins the tie break. I'm looking for a way to automatically compare the tied scores and visually identify the 1st, 2nd and 3rd place winners and the hole that won the tie break. Keep in mind, there could be many teams tied, not just 2 as in the example file.

エクセル ビジュアルベーシック

プロジェクトID: #18603999

プロジェクトについて

2個の提案 リモートプロジェクト アクティブ 5年前

アワード:

aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

$30 USD 2日以内
(118レビュー)
5.9

2人のフリーランサーが、平均$28 で、この仕事に入札しています。

daniyal3214

I am a professional Financial Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel to perform data analysis, financial analysis and financial modeling etc.

$25 USD 1日以内
(50件のレビュー)
5.5