I don't think this one is too crazy, but I am having trouble finding any info about this type of problem.
The goal is to count the number of times in a season that each team scored the highest points in a given week. The columns are labeled by weeks, the maximum per week is below. The end result should be "1" for each team with a red score (weekly high) and "0" for all others. Obviously I could use my fingers to count because we only have 16 weeks, but that would take all the un out of it.
Thanks and Go Lions
<tbody>
</tbody>
The goal is to count the number of times in a season that each team scored the highest points in a given week. The columns are labeled by weeks, the maximum per week is below. The end result should be "1" for each team with a red score (weekly high) and "0" for all others. Obviously I could use my fingers to count because we only have 16 weeks, but that would take all the un out of it.
Thanks and Go Lions
Team | 1 | 2 | 3 | 4 | 5 |
Season 4 Swaggin | 87.80 | 146.93 | 78.30 | 117.87 | 126.93 |
Stu Squad | 82.17 | 104.00 | 134.57 | 104.40 | 91.00 |
Fantasy Enemy No.1 | 127.87 | 132.27 | 96.27 | 122.47 | 58.03 |
terminator | 121.40 | 61.03 | 87.17 | 115.47 | 137.10 |
D-U-Lions | 100.67 | 108.03 | 96.90 | 92.47 | 93.23 |
JC eXpress | 73.50 | 76.77 | 103.77 | 103.07 | 117.70 |
Get Buck | 100.23 | 74.37 | 79.97 | 114.53 | 103.17 |
The Brady Bunch | 97.27 | 108.03 | 75.57 | 134.43 | 83.13 |
ShotThruTheHartline | 97.80 | 107.60 | 80.90 | 78.00 | 90.93 |
Home by Midnight | 85.00 | 67.30 | 84.93 | 104.03 | 111.70 |
Django | 101.77 | 64.03 | 92.43 | 103.63 | 109.00 |
Inj Reserve Pt Tres | 110.13 | 62.37 | 77.23 | 102.33 | 86.43 |
Weekly High | 127.87 | 146.93 | 134.57 | 134.43 | 137.10 |
<tbody>
</tbody>