title: Name of largest row value
body: <p>I have an Excel table that lists various projects from which I would like to return the name of the largest project, based on certain criteria.  This is the table structure:</p>
  
  <pre><code>Project Title (A); Category (B); Completed Year (C); Dollar Amount(D)
  </code></pre>
  
  <p>The array formula below will give me the largest ranking item based on that criteria. However when I try to look up <code>column A</code>, it won't work properly with duplicates, like many zero dollar projects:  </p>
  
  <pre><code>{(LARGE(IF($B$2:$B$1000="Services",IF(YEAR($C$2:$C$1000)=2015,$D$2:$D$1000,""),"‌​"),1)} 
  </code></pre>