Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 18

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Validation Formula?	Ken	Excel Discussion (Misc queries)	5	June 10th 08 10:57 AM
Validation Formula	Teddy-B	Excel Discussion (Misc queries)	7	January 23rd 08 08:53 PM
Validation Formula	Teddy-B	Excel Discussion (Misc queries)	1	January 23rd 08 02:50 PM
Validation Formula	Teddy-B	Excel Discussion (Misc queries)	3	December 28th 06 08:19 PM
Validation Formula	cathyds1	Excel Discussion (Misc queries)	5	November 28th 06 06:54 PM

All times are GMT +1. The time now is 08:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us