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:  J.E. McGimpsey (jemcgimps…@mvps.org)
Date: Thu, 23 Oct 2003

one way:

Select A1:A5. Choose Data/Validation.

Allow: Custom
Formula:  =COUNTA($A$1:$A$5)<=1

You can input your own message in the Error Alert tab of the
Validation dialog.

In article <024101c39996$79721690$a40128…@phx.gbl>,
"AMM" <anonymo…@discussions.microsoft.com> wrote:

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

Replies

None

In response to

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