I have two problems.
1) I want to count the amount of times a unique serial value is used depending on what time it is. In this case if the time is below or above 12:00 hours, K2 (night shift and day shift). I've looked around for this and my answer is in H3 but that's obviously wrong
2) I want to count the average maximum consecutive value (column A) depending on whether it's done on night shift or day shift.
So for example it would be an average of the orange cells in column A depending if it was done on night or day shift. Is this even possible?
Thank you for any help!