Formula
 

Is it posible to put in a formula to ensure there are no duplications when
putting in numbers in cell?

One way

http://www.cpearson.com/excel/NoDupEntry.htm

Regards,

Peo Sjoblom

"Rosie" wrote:

Is it posible to put in a formula to ensure there are no duplications when
putting in numbers in cell?

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

-----Original Message-----
Is it posible to put in a formula to ensure there are no
duplications when
putting in numbers in cell?
.