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!