title: Excel - Finding Max value in a column
body: <p>I have an Summary sheet set up data set up as follows-</p>
  
  <pre><code>         Cat A  Cat B  Cat C  Cat D  
  Name 1       0      0      0      0  
  Name 2       2      3      2      2  
  Name 3       2      2      2      2  
  Name 4       3      2      2      3  
  Name 5       2      3      2      3  
  </code></pre>
  
  <p>I also then have separate tabs for each of Name1 through to Name 5.</p>
  
  <p>The summary sheet contains the maximum values for each category from each tab. So the Cell at Cat A Name 1 should show the maximum value on Sheet(Name1) in the Cat A column.</p>
  
  <p>So far so good. However each tab may not contain the same categories, so therefore I would like teh summary sheet to check the maximum value in each column by doing a search on the Cat name.</p>
  
  <p>So far I have this-</p>
  
  <pre><code>=MATCH(Overview!S$1,Name1!$C$1:$V$1,0)
  </code></pre>
  
  <p>Which returns the column number with the right Category, in this case 13. So I can find the right column. What I am struggling with is to now find the maximum value in the column.</p>
  
  <p>Can anyone help?</p>
  
  <p>Thanks</p>