• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can I create an alert or validation that is dependant upon finding duplicates?


New Member

I'm trying to set up a spread sheet that will list names (col. a) and allocate them gifts from a drop down list (col b). If the person appears in col.a twice I want to either prevent allocation of the same gift twice or create an alert that this person has already been nominated for this gift. Is it possible?


Active Member
Hi Chissy,

Take a look here you could use conditional formatting to give you the alert