Data Validation

D

Donald Dudar

I am trying to build a worksheet to help create schedule assignments.
Columns show the date, and the people being assigned are list in Column A. I
have set up data validation, so that people can only be assigned to specific
tasks, found in the list source. However, I want to ensure that only one
person is assigned to any one task in the list. Later, I will also want to
set up a protocol to make sure that someone is in fact asisgned to every task.

Any suggesdtions on the best way to achieve this?

Thanks
 
B

Bernie Deitrick

Donald,

The specific answer depends on the structure of your workbook. Do you have
a daily list of tasks, with the assigned worker in a column or row for each
day - or do you have a list of workers, with the assigned task associated
with the worker.

Generally, if you want to prevent duplicates in a range, you can select the
range, and use a custom function like

=COUNTIF($D$2:$D$100,D2)=1

where the active cell when the DV is applied to is cell D2, and you don't
want duplicates in D2:D100.

HTH,
Bernie
MS Excel MVP
 
Top