I have a rather complex formula that I need to build. Basically I get a list of data every month, and there is a metric for the first operator of the day. The first column comes in the date and time format. I basically need to write a formula that says if this is the first occurrence of this day then subtract the scheduled time with actual start time. Once I do that I will need to basically say if this is greater than 15 minutes we ding him. So then I'll just have a numerator (number of dings ) and a denominator (total number this operator was first) throughout that month. Any help would be awesome!

  • $\begingroup$ Can you post a data sample, a screenshot, some context? This question might be better suited at SuperUser.com $\endgroup$ – teylyn May 17 '17 at 20:24

I can't comment, hence the answer.

If you could post a sample data here it'd be more helpful.

However, from what I can understand you could use COUNTIF(current row - 1, current row). And then nest it within IF statement -- if(countif = 1, do some calculations, something else).

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.