Scenario: Each column heading is an hour in a day (ex: hr 1, hr 2, hr 3, etc...up to 20 hr.) Each row is a production line (1 thruough 17) These hour 'blocks' are linked to a master schedule which populates each hour and line with an item number. Between jobs, one hour block is left blank (to allow job changeover time) Then the previous item starts up again. I do not need to count these changeovers. When an item run on one line is changed to a new (different) item, there will be one or more blank 'hour blocks' to allow equipment changes etc... I need to count how many of these new item changeovers are occurring in one day.
Example: Line # hr1 hr2 hr3 hr4 hr5 hr6 Line1 itemA itemA itemA itemA itemA Line2 itemB itemB itemC itemC Line3 itemD itemD itemD itemD itemE In the above example the count of changeovers would be 2 since line 1 is not a new item changeover. Please note that the changeover for a different item could take 1 or more hour s. Any thoughts? --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
