title: How to get the last date in a range for each category
body: <p>I'm trying to display the latest transaction date for each customer in Sheet 2 but can't seem to get it right in google sheets. Can anyone help me with the right formula?</p>
  
  <p>Sheet 1:</p>
  
  <p><a href="https://i.stack.imgur.com/ZuzWy.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZuzWy.jpg" alt="enter image description here"></a></p>
  
  <p>Sheet2:</p>
  
  <p><a href="https://i.stack.imgur.com/Mt9ub.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Mt9ub.jpg" alt="enter image description here"></a></p>