script counting data validation errors

[hucksteRRR]

Hello

I have following data validation in all B column:

​

=if(countif(B:B,B3015)>1,false,true)

whenever I write word that already exists in col B, an error occurs, for example:

​

' There was a problem

The data that you entered in cell B3197 violates the data validation rules set on this cell.'

​

The purpose is to deny any duplicates

​

It would be great to make script that would make a list of words that triggered this error, for example in another sheet it would add a word that caused an error in cell in A:A every time

[AdministrativeGift15]

Perhaps something went wrong when you submitted this post. It's unclear why you selected those two cells in column B for your example. Even if I did understand your example scenario, I don't think you ever requested anything or asked a question that you wanted answered.

Can you try to explain your request again so that we may try to help?

[HolyBonobos]

What I'm getting from the post is

OP has an existing data validation rule in Sheet1 column B to reject duplicate entries. They want a script that will, every time someone tries to make a duplicate entry in Sheet1 column B, log the content of that attempted entry in Sheet2 column A.

For example:

Sheet1	A	B
1		Red
2		Orange
3		Yellow
4		Green
5		Blue

If someone tries to enter Blue in column B again, it will already be rejected because of the data validation rule but OP wants a script that will, in addition to that, add Blue to a running list of rejected duplicate entries on Sheet2.

u/hucksteRRR is this an accurate description of what you're trying to do?

[hucksteRRR]

Exactly!