Hello,
I want to create a simple form for people who come to do a one-time trial lesson at my gym.
So I want to create a form where we can fill in name, phone number and email. But I want to avoid filling in duplicates.
I saw some examples with = COUNTIF ($ A $ 2: $ A $ 20, A2) <= 1
But when I try I get an error.
It would be nice if it is possible to create a warning box, so if you duplicate a word, you get a warning: "This name already exists, do you want to continue?" If you press yes it will be duplicated and if you say no it will be deleted ..?
Does anyone have an idea?
Regards,
I want to create a simple form for people who come to do a one-time trial lesson at my gym.
So I want to create a form where we can fill in name, phone number and email. But I want to avoid filling in duplicates.
I saw some examples with = COUNTIF ($ A $ 2: $ A $ 20, A2) <= 1
But when I try I get an error.
It would be nice if it is possible to create a warning box, so if you duplicate a word, you get a warning: "This name already exists, do you want to continue?" If you press yes it will be duplicated and if you say no it will be deleted ..?
Does anyone have an idea?
Regards,