How do I add a constraint in Excel solver to indicate only cell to be filled in in a row of cells. This is the constraint I'm trying to add in Excel, "assume that by contract each of the 10 sectors can only be assigned to ONE of the 5 disposal sites so that drivers do not have to carry snow to multiple sites."
Solved by O. F. in 12 mins