I have tried numerous variations to successfully combine the following two expressions, and would greatly appreciate any support. I want to present an ordered list and stop a duplicate value being entered. I can successfully stop a duplicate value be...

It's a fairly trivial ask but i'm stumped on how to approach the problem. As the title suggests i'm creating a personal app to capture stats from Football matches. I have a few source tabs in a single sheet, Players, Fixtures, Results. Goals, Assists...