Find last row of data with given status

Dear Community,

I have data about client ratings for 18 months in a row. Not all clients have data for all 18 months (i.e., if onboarded later of left us earlier). The ratings have 2 possible statuses: valid or aged. Each client in the dataset was both valid and aged during the 18 months, BUT we do not know when the rating turned from valid to aged.

Is there any way to find the LAST valid rating, no matter which month it was, using - maybe loops? Or other nodes?

Thank you!