title: VBA - Find max value for each category
body: <p>I have a table of data in Excel and am trying to figure out how I can loop through the column taking the value associated with the max year. Then move onto the next property. Sample of the data is below:</p>
  
  <p><a href="https://i.stack.imgur.com/OPbwm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OPbwm.png" alt="enter image description here"></a></p>
  
  <p>What I'm trying to get to is below:</p>
  
  <p><a href="https://i.stack.imgur.com/N9oRx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N9oRx.png" alt="enter image description here"></a></p>
  
  <p>Not even quite sure where to start with this. I have tried looking for Max year but haven't been able to go again when I get to a new property name.</p>
  
  <p>Thanks</p>
  
  <pre><code>Property    Year    Value
  Apartment A 2013     64,516 
  Apartment A 2015     92,805 
  Apartment B 2018     9,426,984 
  Apartment B 2018     12,569,312 
  Apartment C 2018     160,061 
  Apartment C 2019     161,882 
  Apartment D 2018     281,979 
  Apartment E 2016     -   
  Apartment F 2017     1,875,000 
  Apartment F 2018     2,062,500 
  </code></pre>