try this

=AND(COUNTIF($G$2:$G$10,G2)=1,AND(G2919811111111, G2<919999999999))




On Oct 24, 3:06*pm, RK wrote:
=AND(COUNTIF($G$2:$G$9990,G2)=1,919811111111<G2<91 9999999999)
After validating a column of cells (upto 9990) with this formula no number
is allowed to enter in any cell. Where is the problem?

My aim is to
1. enter non repeated numbers in a column
2. the numbers should be exactly 12 digits not less than or grater than that.

Anybody able to correct the formula above or suggest an alternate Please.......
Yes, I use Excel 2007.