title: Determining a group of duplicates and finding its max/highest no
body: <p>Unsure if the solution is VBA/Macro or a formula in excel. However the goal is copying Value of the Highest/Max Term # within a group of accounts having the same account name to it's corresponding AValue. [Image below]</p>
  
  <p>Note: The accounts are already sorted and cannot be sorted to another format as it deals with 7000+ entries</p>
  
  <p><a href="https://i.stack.imgur.com/PcWWf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PcWWf.png" alt="screenshot"></a></p>