• 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

    Hui...

  • 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?

Chrissy

New Member
Hi,

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?
 

oldchippy

Active Member
Hi Chissy,


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


http://chandoo.org/wp/2010/01/06/highlight-repeat-customers/
 
Top