validation Formula

[RK]

=AND(COUNTIF($G$2:$G$9990,G2)=1,919811111111<G2<919999999999)
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.

 

[muddan madhu]

try this

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

 

[RK]

Hi Madhu

Thanks for your suggesion, unfortunately this also does not work.

RK

 

[RK]

Thanks Madhu, unfortunately this does not work

try this

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

 

[John C]

His formula works for me.
=AND(COUNTIF($G$2:$G$9990,G2)=1,AND(G2>919811111111,G2<919999999999))

Perhaps you could post the formula that you used from his response?