G Guest Feb 2, 2005 #1 Is it posible to put in a formula to ensure there are no duplications when putting in numbers in cell?
Is it posible to put in a formula to ensure there are no duplications when putting in numbers in cell?
J Jason Morin Feb 2, 2005 #3 There's a simple method using COUNTIF and Validation. See Debra Dalgleish's website for specific instructions: http://www.contextures.com/xlDataVal07.html#Unique HTH Jason Atlanta, GA
There's a simple method using COUNTIF and Validation. See Debra Dalgleish's website for specific instructions: http://www.contextures.com/xlDataVal07.html#Unique HTH Jason Atlanta, GA