Hi Matt,

Welcome to forum.

Please attach your sample spreadsheet with expected result for better understanding to get solution fast way.