Re: Allowing only 1 cell input in a cell range of 5

Giganews Newsgroups
Subject: Re: Allowing only 1 cell input in a cell range of 5
Posted by:  Ken Wright (ken.wrig…@NOSPAMntlworld.com)
Date: Thu, 23 Oct 2003

Select A1:A5, do Data / Validation / Custom / Put in the Formula:-

=COUNTA($A$1:$A$5)<=1

Hit OK.

--
Regards
          Ken.......................    Microsoft MVP - Excel
                  Sys Spec - Win XP Pro /  XL2K & XLXP

----------------------------------------------------------------------------
  Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

"AMM" <anonymo…@discussions.microsoft.com> wrote in message
news:024101c39996$79721690$a40128…@phx.gbl...
> How do I set up 5 separate cells to only allow entry into
> 1 of those cells?
>
> For example, in Column A, rows 1 -5, I want to be able to
> input an "X" into only one row, such as row 3. If I try
> to input into row 1, 2, 4, or 5, I want a message to pop-
> up saying that is not allowed.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system http://www.grisoft.com).
Version: 6.0.528 / Virus Database: 324 - Release Date: 16/10/2003

Replies

In response to

Allowing only 1 cell input in a cell range of 5 posted by AMM on Thu, 23 Oct 2003