What is the method for preventing duplicate entries?

Duplication.xlsx (9.0 KB)

Welcome back to the community, @meaf! Maybe this post discussed previously should help you solve your issue: