| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a schedule without repeating names
I'm trying to create a schedule for weekend duties, without repeating names
of the people involved, so that more than one job is not assigned to a person |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create a schedule without repeating names
Marilinn,
Please do the following steps: Suppose that you have your list from A1 to A10, from the Data menu choose validation and from Allow drop down list choose CUSTOM and in the formula bar put this: =Countif($A$1:$A$10,A1)=1 Let me know if this works. Daoud Fakhry "marilynn" wrote: I'm trying to create a schedule for weekend duties, without repeating names of the people involved, so that more than one job is not assigned to a person |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeating names in row fields of a pivot table | Excel Discussion (Misc queries) | |||
| How to filter repeating Names | Excel Discussion (Misc queries) | |||
| Generating a repeating list of names from an ever changing roster. | Excel Worksheet Functions | |||
| Create patient schedule based on master therapist schedule | Excel Discussion (Misc queries) | |||
| List of repeating names | Excel Worksheet Functions | |||
Linear Mode
