validation Formula
 

=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.

validation Formula
 

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.

validation Formula
 

Hi Madhu

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

RK

"muddan madhu" wrote:

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.

validation Formula
 

Thanks Madhu, unfortunately this does not work

"muddan madhu" wrote:

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.

validation Formula
 

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

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

--
** John C **

"RK" wrote:

Hi Madhu

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

RK

"muddan madhu" wrote:

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.