Ah got it. If you want this all in one formula, I wouldn't know how (but it's probably possible). If you are OK with adding helper columns, I think I can help you...