Sum Of Columns Cannot Exceed One(1)
You can use data validation. Say we only want a single entry in cells A1
thru E1
In cell A1 set data validation to:
Settings Custom Formula is
=COUNT($A$1:$E$1)<2
Then copy A1 to B1 thru E1
Excel will allow only one of the cells to be set.
--
Gary's Student
gsnu200705
"TonyD" wrote:
I have a worksheet that has a section of columns called Outcome. The Outcome
row section cannot exceed one (1). Basically the operator can only choose one
of five cells to enter a value not exceeding one(1). What can I use to
accomplish this? I tried using Data Validation and it only seems to work for
one cell only.
|