If returns True for one apply to all subsequent and previous entities

Hello everyone,

I hope you can help been trying to work this one out for what seems like ages now.

Basically I have a spreadsheet that I use to check my gambling accumulators. An accumulator is a bet that is outcome linked to other bets and because of the way they work here you get your money back if one bet lets you down. So each accumulator ID I have is live until it has lost twice at which point it becomes fully dead and I enter a loss.

I am using the following formula and it highlights when there has been two losses but what I want to do is apply it to all subsequent entities of the same name.

=AND(IF(COUNTIFS($D:$D,$D2,$F:$F,$F2)>1,TRUE,FALSE),$F2="L")

Where column D is the unique identifier of the accumulator and column F tracks the wins against it.

So if i have an entity "LB 01/11" that has lost (represented in the F colomn as L) yesterday and today it picks up that and uses conditional formatting to put a strike-through the two rows highlighting it as dead but not for subsequent entities.

I hope I've explained it. It's probably much simpler than I've made it sound but hopefully you can help. Would make my life so much easier!

Thanks in advance!

Nick

Hi, and welcome to the forum.

It would be even easier for us if you could upload an example of the workbook and your data. Manually add the results you expect to see with notes explaining the results where necessary.