An explanation in words would attract more responses than having to look at a 12 min long video. It would also help you to better understand your own problem

Also post your sheet with a macro and expected results. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post