Data Validation
 

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

Data Validation
 

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


"Donald Dudar" wrote in message
...
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