title: Returning the highest value with different row lengths in Excel
body: <p>I am working on an Excel file that gives different shareholder ratios per company. Now, I want to find the highest value of those ratios per company. The issue is that the number of ratios is different per company. So, company X has 11 shareholders and company Y has 7 shareholders. These ratios are presented in different rows, while the company name is in the first row (different column though).</p>
  
  <p>Now, I want to return the highest ratio per company.</p>
  
  <p>This is how the excel file looks:</p>
  
  <pre class="lang-none prettyprint-override"><code>Company X   Company X   51,42
              Company X   n.a.
              Company X   n.a.
              Company X   3,58
              Company X   2,96
              Company X   2,33
              Company X   1,18
              Company X   n.a.
              Company X   0,79
              Company X   0,71
              Company X   0,66
  Company YON Company YON n.a.
              Company YON n.a.
              Company YON 8,94
              Company YON n.a.
              Company YON n.a.
              Company YON 1,03
              Company YON 0,91
  </code></pre>