title: Check Multiple Columns for the highest value
body: <p>So say I had a table like this that has the score of 3 different teams for the week. </p>
  
  <pre><code>Day   Team1 Team2  Team3
  Mon     5     2      2
  Tue     0     7      7
  Wed     6     3      2
  Thu     0     0      1 
  Fri    13     6      5
  </code></pre>
  
  <p>I want a formula that can find the highest score for the day and mark it on a identical table with a value of 1 and mark the other teams 0.</p>
  
  <p>If there are 2 values that are the highest I want them to both be marked 1.</p>
  
  <p>There will never be day with all 0's </p>
  
  <p>Using the data from the table above my other table would look like this. </p>
  
  <pre><code>Day   Team1 Team2  Team3
  Mon     1     0      0
  Tue     0     1      1
  Wed     1     0      0
  Thu     0     0      1 
  Fri     1     0      0
  </code></pre>
  
  <p>I have a working formula</p>
  
  <pre><code>=IF(AND(B2&gt;=$C2,B2&gt;=$D2,B2&gt;=$E2),1,0)
  </code></pre>
  
  <p>I was just hoping there was a better way to write this formula, so that I can drag it across the teams and have it still work.</p>
  
  <p>If I try to drag my formula now. I have to update the formula for each column. Sometimes I might have 20 + teams.</p>
  
  <p>Any advice is appreciated. </p>