software

Hi,

How can I set the validation like this formula?
=countif(rngCheckColumn, CheckCelladdr)lt;=1--
gabch
------------------------------------------------------------------------
gabch's Profile: www.excelforum.com/member.php...oamp;userid=30662
View this thread: www.excelforum.com/showthread...hreadid=542368Assuming A1:A10 is the range of concern, give it the RangeName of quot;TheRangequot;,
by highlighting it and doing Insert gt; Name gt; Define gt; and typing quot;TheRangequot;
(without quotes) in the small upper box of the pop-up.

Then assuming B1 is the cell you wish to validate, click on it and do Data gt;
Validation gt; choose Custom in the Allow: window gt; and in the Formula: window
type =COUNTIF(TheRange,B1)gt;=1 and click OK

hth
Vaya con Dios,
Chuck, CABGx3
quot;gabchquot; wrote:

gt;
gt; Hi,
gt;
gt; How can I set the validation like this formula?
gt; =countif(rngCheckColumn, CheckCelladdr)lt;=1
gt;
gt;
gt; --
gt; gabch
gt; ------------------------------------------------------------------------
gt; gabch's Profile: www.excelforum.com/member.php...oamp;userid=30662
gt; View this thread: www.excelforum.com/showthread...hreadid=542368
gt;
gt;