Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IF(AND(INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0))-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+1)>=-0.1,INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0))-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+1)<=0.1),INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)),IF(AND(INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+2)-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+3)>=-0.1,INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+2)-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+3)<=0.1),INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+2),""))
- =IF(AND(INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0))-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+1)>=-0.1,INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0))-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+1)<=0.1),INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+1),IF(AND(INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+2)-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+3)>=-0.1,INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+2)-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+3)<=0.1),INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+3),""))
- =IF(AND(INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0))-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+1)>=-0.1,INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0))-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+1)<=0.1),INDEX(B2:I2,MATCH(TRUE,INDEX((B3:I3<>0),0),0)),IF(AND(INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+2)-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+3)>=-0.1,INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+2)-INDEX(B3:I3,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+3)<=0.1),INDEX(B2:I2,MATCH(TRUE,INDEX((B3:I3<>0),0),0)+2),""))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement