title: MAX + Left Function Excel
body: <p>I am trying to get the max value of a column based on the <code>Left</code> function</p>
  
  <p>What I am doing is the following :</p>
  
  <p><a href="https://i.stack.imgur.com/UuV0J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UuV0J.png" alt="enter image description here"></a></p>
  
  <p>These are the results I get when i write this into column C : </p>
  
  <pre><code>=MAX(LEFT(A:A, 2))
  </code></pre>
  
  <p>But what I truly want is to get in column C the max value of all column A not for each cell.</p>
  
  <p>So the result should be in this case 90 for all rows.</p>
  
  <p>What should be the formula here?</p>