G Guest Jan 5, 2004 #1 I WANT TO SET UP A VALIDATION RULE THAT APPLIES ONLY TO A SPECIFIC COLUMN (INSTEAD OF ENTIRE WORKSHEET), AND ALLOWS DUPLICATE DATA TO BE ENTERED ONLY ONCE. PLS HELP ME!
I WANT TO SET UP A VALIDATION RULE THAT APPLIES ONLY TO A SPECIFIC COLUMN (INSTEAD OF ENTIRE WORKSHEET), AND ALLOWS DUPLICATE DATA TO BE ENTERED ONLY ONCE. PLS HELP ME!
R Ron de Bruin Jan 5, 2004 #2 Try this example from Chip Pearson http://www.cpearson.com/excel/NoDupEntry.htm http://www.cpearson.com/excel/duplicat.htm
Try this example from Chip Pearson http://www.cpearson.com/excel/NoDupEntry.htm http://www.cpearson.com/excel/duplicat.htm
