title: find most recent date with unique reference excel
body: <p>I have a list of data (I can't sort, filter or delete it as its used by others) where I want to find the most recent date per account. 20,000 lines of data.</p>
  <p>I've used this formula in column C</p>
  <pre><code>=IF(MAX(IF($B$2:$B$16=B2,$A$2:$A$16))=A2,&quot;Yes&quot;,&quot;no&quot;)
  </code></pre>
  <p>However it looks at all the data in column B, it doesn't identify the unique accounts. There should be another Yes in cell C3</p>
  <p>Does anyone know how I can resolve this?</p>
  <p><a href="https://i.stack.imgur.com/1BwZN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1BwZN.png" alt="enter image description here" /></a></p>