title: How to get max and min value with other column's values in excel?
body: <p>I want to get max and min values with other column's values in ms excel 2007. I have two columns</p>
  
  <pre><code>| Column A | Column B |
  -----------------------
  |A         |   18     |
  -----------------------
  |B         |   78     |
  -----------------------
  |c         |   9      |
  </code></pre>
  
  <p>I want to  print out max values and min values of "Column B" with "Column A" values. Please suggest me some formula.</p>