| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ensuring 3 cells do NOT match
I'm back with another problem :-)
I work a crew schedule; and I have 3 people who cannot work a shift together. I need something that will NOT allow me to put them on a shift together. We identify our shifts by D, S, or M (days, swings, mids) So I cannot have Buck, Earle, or Small working a shift together. (weird rules about these three) I can't use conditional formatting for this because I already have used all 3 conditions for another issue. Is there a way I can "raise a flag" if I schedule 2 or more of them on the same shift? Here's an idea of my schedule Earle is in C7, Buck is in C27, and Small is in C51. If I were putting day shift together in column D, then D7, D27, and/or D51 cannot match. Any ideas O' Smart Excel people? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| Look for a value in two cells and match it with another | Excel Discussion (Misc queries) | |||
| Match cells with cells on another workbook | Excel Worksheet Functions | |||
| Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
| Ensuring deleted data cannot be recovered | Excel Discussion (Misc queries) | |||
Threaded Mode
