determine first of the day in a sequence and how many are needed to become good

[dannaer]

Hi all,

i'm searchin for a way to calculate an activity before the outcome is good.
I have 2 columns given dates and the outcome good or bad.

now i want in the 3th column the amount of bad tries that occured before the first "good" came out. ( than also need to put value 1 i the 4column) .
i's possible that there are after the "first good" of the day more attemps, do's i'm not intressted in and needs to be blank.

thanks in advance for helping to solve

a small example column 3 and 4 are done by hand now
example.xlsx

Thanks to all who have take a look and try to help solving my problem. the solution that came out works fine and i can continue with my project. thanks a lot

[Glenn Kennedy]

Your explanation makes no sense to me at all.

Kindly try to explain again.

ALSO explain in detaiil your expected results for rows 7, 11 & 15 (and to be honest... most if not all of the other rows as well!!).

[DJunqueira]

You have unique days as 1 in column B, but in row 6 it is 0, why?

[dannaer]

thank you for take a look at my problem,

I noticed that i copied the wrong values in column c.
What I want to achieve, I want to be able to sort by what was the first "good" one on a day, and in the column before it how many bad attempts preceded it. attempts that occur later in the day after the first good attempt (good or bad) have no added value in the overview. These are only kept for the number of attempts made.
I don't know how to explain that in the rows of Excel, but I have now added the correct data and the filter that I want to apply.

Thank you in advance for your consideration and your patience with my strange explanation

example.xlsx

[DJunqueira]

My proposal.

Please Login or Register  to view this content.