Hello and good morning,

I have a brain teaser today. I'm working on a report where i need to find the last date a payment was made by a certain client. The problem is that not all clients have the same amount of payments so I cant just choose a payment number in my formula. Please see the attached and let me know if you can figure this one out for me.

Thank you all in advance,
Trishlast payment.xlsx