I want to use a function that will input the number 3 if a work center shift 1 and 2 occurs on the same from date. Also, If the condition is met, I only want to put it on the row where it first ocured.
Please see attached example worksheet.
+ I also have a part two that I need help with if any of you have conditional formatting experience.
Thanks in advance.