Resolved: I need prevent and alert users whenever their entry is a duplicate in google sheets

Question:

I’m managing a tracker in google sheets, where users should enter new IDs in column A. I need to prevent them, as well as alert them, whenever their entry is a duplicate (so the ID already exists in column A). Data validation isn’t a good option. How should I go about this?

Answer:

we do with data validation with formula

If you have better answer, please add a comment about this, thank you!