Most improved player every week

[adatom]

Hello again, this message board was so useful last time I decided to try again. I want to add a feature to my Golf Program's Dashboard that pulls in the top three most improved golfers each week.

The formula would have to reference a cell that has which week it is while referencing the scores for that week and then compare the difference of the current and previous weeks while returning a name. Then use vlookup again to lookup the name and bring in the +# better than last week.

For example:

Say week reference cell is D3. The player names are in cells AL42:AL94 with each weeks score starting in column AM and end at column BC.

This formula would make my Dashboard complete and could really use a hand.

Thanks!

 

[kevinb11]

Can you post a sample of your data please and what the result you are looking for?

 

[adatom]

Can you post a sample of your data please and what the result you are looking for?

Hello Kevin and thank you for your response. I am currently at home and I dont think the html posting software add-ins work with Mac versions.

However, it isn't quite crazy as to what I want to accomplish and should be easy for someone with extensive Excel knowledge.

Rows = each players weekly score, retrieved from the scoring sheet that I have already.

Columns = 1st column is the players namers while the rest represent each week (1-17)

The formula must be able to 1) recognize which week it is, say for example we have completed 3 weeks of league and this week we will golf 'week 4'.

Giving its the 4th week, the formula would need to recognize week columns 2&3 and compare who did marketably better (greatest improvement/biggest difference in score) and send that to the cell with the formula (most likely by =vlookup). Then I would use vlookup to bring in the value of that improvement to go with the name, like a score card more or less:

Most Improved Players
1) Adam Example +4
2) Chris Example +3
3) Bob Example +2


Hope this helps and thanks again!

 

[lrobbo314]

There goes my idea to use VBA since you're on a MAC.

Anyway, I feel like I'm onto something here but just can't get there.

<TABLE style="WIDTH: 879pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1172><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 48pt" span=11 width=64><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 20.25pt" height=27><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 53pt; HEIGHT: 20.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=27 width=71></TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>1</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>2</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>3</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>4</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>5</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>6</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>7</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>8</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>9</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>10</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>11</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=77>12</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>13</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>14</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>15</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>16</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>17</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Steve</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>108</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>114</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>71</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>87</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>87</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>87</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>70</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>84</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>73</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>85</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>79</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>102</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>112</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>120</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>118</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>93</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>110</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Bill</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>110</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>103</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>92</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>107</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>98</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>70</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>74</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>82</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>95</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>114</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>93</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>105</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>78</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>87</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>70</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>96</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Charles</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>119</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>71</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>109</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>78</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>71</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>70</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>89</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>112</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>101</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>85</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>73</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>109</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>101</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>108</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>112</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Kevin</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>115</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>79</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>72</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>99</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>71</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>82</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>72</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>94</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>88</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>82</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>102</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>120</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>104</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>109</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>106</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>92</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>93</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Jose</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>92</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>113</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>88</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>88</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>96</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>95</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>105</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>101</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>77</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>88</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>85</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>83</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>96</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>103</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>74</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=22></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63></TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>21</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>38</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>27</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>10</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>11</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>22</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>22</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>23</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>13</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>20</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>23</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>36</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>13</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>9</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>9</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>43</TD></TR></TBODY></TABLE>


I set the data up like this, I think this is how he has it more or less.

In the bottom row I've dragged the following formula to find out the highest most improved score.

{=MAX((D24:D28)-(C24:C28))}

But, that's where my juice ends. I've tried index/match and lookup to try and connect the highest most improved score with the golfer that got it, but I'm not getting anywhere with it.

Now I want the answer. It seems like there should be a solution to this that I'm just not seeing.

 

[adatom]

There goes my idea to use VBA since you're on a MAC.

Anyway, I feel like I'm onto something here but just can't get there.

<TABLE style="WIDTH: 879pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1172><COLGROUP><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 48pt" span=11 width=64><COL style="WIDTH: 58pt; mso-width-source: userset; mso-width-alt: 2816" width=77><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 20.25pt" height=27><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 53pt; HEIGHT: 20.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=27 width=71></TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>1</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>2</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>3</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>4</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>5</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>6</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>7</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>8</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>9</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>10</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>11</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 58pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=77>12</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>13</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>14</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>15</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>16</TD><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 width=64>17</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Steve</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>108</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>114</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>71</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>87</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>87</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>87</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>70</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>84</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>73</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>85</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>79</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>102</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>112</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>120</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>118</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>93</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f 0.5pt solid; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>110</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Bill</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>110</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>103</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>92</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>107</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>98</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>70</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>74</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>82</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>95</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>114</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>93</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>105</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>78</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>87</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>70</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>96</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Charles</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>119</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>71</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>109</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>78</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>71</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>70</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>89</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>112</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>101</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>85</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>73</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>109</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>101</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>108</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>112</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Kevin</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>115</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>79</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>72</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>99</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>71</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>82</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>72</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>94</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>88</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>82</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>102</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>120</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>104</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>109</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>106</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>92</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>93</TD></TR><TR style="HEIGHT: 21pt" height=28><TD style="BORDER-BOTTOM: #4f81bd 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 21pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl67 height=28>Jose</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>92</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>113</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>88</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>88</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>96</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>95</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>105</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>101</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>77</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>88</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>85</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>83</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>96</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>103</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>74</TD><TD style="BORDER-BOTTOM: #7f7f7f 0.5pt solid; BORDER-LEFT: #7f7f7f; BACKGROUND-COLOR: #ffcc99; BORDER-TOP: #7f7f7f; BORDER-RIGHT: #7f7f7f 0.5pt solid" class=xl65>117</TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=22></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63></TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f 2pt double; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>21</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>38</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>27</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>10</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>11</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>22</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>22</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>23</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>13</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>20</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>23</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>36</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>13</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>9</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>9</TD><TD style="BORDER-BOTTOM: #3f3f3f 2pt double; BORDER-LEFT: #3f3f3f; BACKGROUND-COLOR: #a5a5a5; BORDER-TOP: #3f3f3f 2pt double; BORDER-RIGHT: #3f3f3f 2pt double" class=xl64>43</TD></TR></TBODY></TABLE>


I set the data up like this, I think this is how he has it more or less.

In the bottom row I've dragged the following formula to find out the highest most improved score.

{=MAX((D24:D28)-(C24:C28))}

But, that's where my juice ends. I've tried index/match and lookup to try and connect the highest most improved score with the golfer that got it, but I'm not getting anywhere with it.

Now I want the answer. It seems like there should be a solution to this that I'm just not seeing.

I like the attempt and you're roughly where I ended when I left work. I have the newest version of Office (11) for Mac and VBA can be used if you have a solution that way (although I am no good with VBA). The hardest part is looking up the name once the largest increase has been identified. I hope someone has a solution, it'd be great to have for the 'not so good golfers who never end up on the lowest average leaderboard'.

 

[kevinb11]

It will be a lot of work, but I thought of using reference cells by week.

First getting the difference and second ranking them to put in your list.

Here is what I have so far:

Excel Workbook
	A	B	C	D
1		1	2	3
2	Adam	43	44	40
3	Chris	45	47	44
4	Bob	46	48	46
Scoring

Excel Workbook
	T	U	V	W
1		2		3
2	-1	1	4	1
3	-2	2	3	2
4	-2	2	2	3
Scoring

 

[kevinb11]

From here you could use an index match to look up the name by ranking. I have the rankings set up like this for a possible reference cell to use in the index match formula.

Excel Workbook
	A	B	C
1		WEEK	3
2		Most Improved Players	Score
3	1
4	2
5	3
6	4
Stats

 

[adatom]

You're on your way, but don't forget that you will have to break ties with a COUNTIF( , , , )-1 addition to your ranking so you don't get an N/A. It is a lot of work but, if you seen all the hidden information on the dashboard sheet, you wouldn't think much of it.

Anyone else have a suggestion, since I've been shown up on here many times.

 

[adatom]

Any thought on being able to only retrieve an individual week and have it pull onto the Dashboard? From what you have now it looks like it will just be a list of each weeks most improved players, without having the ability to pull into anything.

 

[kevinb11]

Ok, here is where I am currently at:

Excel Workbook
	A	B	C
1	WEEK	3
2	Players	Difference	Rank
3	Adam	4	1
4	Chris	3	2
5	Bob	2	3
Dashboard

As you change B3 it will change each players difference and rank.

Not exactly as you wanted, but something close.
Maybe you can figure out a way to get them to appear in order.

<table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td>Spreadsheet Formulas</td></tr><tr><td><table style="font-family:Arial; font-size:9pt;" border="1" cellpadding="2" cellspacing="0"><tr style="background-color:#cacaca; font-size:10pt;"><td>Cell</td><td>Formula</td></tr><tr><td>B3</td><td>=VLOOKUP(A3,Scoring!$A$12:$B$14,2,FALSE)</td></tr><tr><td>C3</td><td>=VLOOKUP(A3,Scoring!$A$18:$B$20,2,FALSE)</td></tr><tr><td>B4</td><td>=VLOOKUP(A4,Scoring!$A$12:$B$14,2,FALSE)</td></tr><tr><td>C4</td><td>=VLOOKUP(A4,Scoring!$A$18:$B$20,2,FALSE)</td></tr><tr><td>B5</td><td>=VLOOKUP(A5,Scoring!$A$12:$B$14,2,FALSE)</td></tr><tr><td>C5</td><td>=VLOOKUP(A5,Scoring!$A$18:$B$20,2,FALSE)</td></tr></table></td></tr></table>

Excel Workbook
	A	B	C	D	E	F	G	H
1		1	2	WEEK 2 Difference	Week 2 Rank	3	WEEK 3 Difference	Week 3 Rank
2	Adam	43	44	-1	1	40	4	1
3	Chris	45	47	-2	2	44	3	2
4	Bob	46	48	-2	2	46	2	3
5
6
7
8
9
10
11
12	Adam	4
13	Chris	3
14	Bob	2
15
16
17
18	Adam	1
19	Chris	2
20	Bob	3
Scoring