Quote:
Originally Posted by kalchakra
Hi,
I am new to the forum! my friends talk a lot about this and glad to be in the forum using Office 2007.
My question---
I work in a manufacturing company which makes different sizes of Nuts on many machines. One machine can do only one size of Nuts for a particular period and can be molded for another variant.I manage an excel sheet defining the date ranges of the machine utility for a particular Nut, this allows us to mark our next point for another size.
The problem is.. after fixing dates for a process on a machine, I many time loose track of the previous marked dates and issue new dates for the same machine that is usually overlapping and lately found out.
Please help me with a solution ~~~ which does not allow overlapping of dates on a particular machine unless the previous dates alloted be changed.
Machines Start date End date
Machine 1 1/25/2011 2/7/2011
Machine 2 1/2/2011 1/25/2011
Machine 3 1/2/2011 1/25/2011
Machine 1 2/19/2011 3/22/2011
Machine 1 1/27/2011 2/11/2011
I use the Table feature of Excel 2007 for this data
|
Try using the following formula. Copy and paste it next to each line. Using this formula against your example above it results in the first three and last date ranges all have overlaps. Only the 4th date range has no overlaps.
=IF(SUMPRODUCT((B$2:B$6<=C2)*(C$2:C$6=B2))1,"Thi s range Overlaps","")
Similar Threads
Hybrid Mode
