Multiple conditions that depend on date, result and repeated names

Looking for a formula/array that will "write an "x"" in column D when the following conditions occur:

1. date is prior to date in column A
2. text is the same as in column B
3. the last value in column C is "1" (on rows that have the same name as B)

For example: If on 4.11, Eugene has a "1" in Column C, then then column D for 4.10 should have an "x", otherwise it would be blank...

As soon as Joey gets a "1" as a result, all the previous dates should become "x"... pretty much everything for Joey before the last "1" should automatically be "x".

https://docs.google.com/spreadsheets/d/1lhL7w411XkgZpXpBTphy1yIioVPlYfSJBRXAdTTH-4s/edit?usp=sharing

Date	Name	Result	 Reset Fx 
4.10	Eugene	0	 FALSE 
4.10	Joey	0	 FALSE 
4.11	Eugene	1	 x 
4.11	Joey	0	 FALSE 
4.12	Joey	0	 FALSE 
4.15	Joey	0	 FALSE 
4.18	Joey	0	 FALSE 
4.18	Joey	0	 FALSE 
4.19	Joey	0	 FALSE 
4.21	Joey	1	 x 
4.22	Tony	0	 FALSE 
4.22	Joey	0	 FALSE 
4.23	Andy	0	 FALSE 
4.23	Andy	0	 FALSE 
4.23	Tony	0	 FALSE 
4.24	Tony	0	 FALSE 
4.24	Tony	0	 FALSE 
4.24	Andy	0	 FALSE 
4.24	Andy	1	 x 
4.25	Tony	0	 FALSE 
4.25	Andy	0	 FALSE 
4.25	Andy	0	 FALSE 
4.25	Andy	0	 FALSE 
4.25	Eugene	0	 FALSE 
4.25	Eugene	0	 FALSE 

I have tried arrays, if, ifs, if w and...
I get stuck trying to get the repeated name and the prior dates to get a result in a different cell.

If I am understanding the question correctly, you want column D to be x for every instance of a name before the date it is marked as 1. I solved it assuming that 1 would only be input for only one date for each name. I used a combination of match, index, and filter to determine which date had the 1 for each name and use that date and name as a reference for the prior date. Hope this helps!

=IFERROR(IF(AND(B2=(INDEX(FILTER($B:$B,$B:$B=B2,0),MATCH(1,FILTER($C:$C,$B:$B=B2,0),0),1)),
A2<=(INDEX(FILTER($A:$A,$B:$B=B2,0),MATCH(1,FILTER($C:$C,$B:$B=B2,0),0),1))),"x",""),"")

I figured it out. You guys got me on the right track.

=iferror(if(A2<=index(filter($A$2:$A,$C$2:$C=1,$B$2:$B=$B2),sumproduct(--($C$2:C=1),--($B$2:$B=$B2))),"x",""),"")

I have to drag it down because it won't work as arrayformula, but it does what I need.
The example sheet shows the results.