According to the second line of the third line,,, a fixed value, returns the value corresponding to the first line, third line from the second line to find a fixed value is repeated, is a time sheets, which day to work overtime, marked the first line is the date, the second and third lines appear "overtime" will return to the date of the first line, how to do? Function of how to implement or VBA, thank you all for the great god

CodePudding user response:

I say a simple point, you can change the way of thinking, change work overtime to 0,=IF (B1, B2=0, 0)