Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Formula? | Excel Discussion (Misc queries) | |||
Validation Formula | Excel Discussion (Misc queries) | |||
Validation Formula | Excel Discussion (Misc queries) | |||
Validation Formula | Excel Discussion (Misc queries) | |||
Validation Formula | Excel Discussion (Misc queries) |