#### andrichara

##### New Member

- Joined
- Jan 13, 2019

- Messages
- 14

the formula is working until 2 apears ,it shows 0zero but it stops, imean the zero is permanent,i want the formula to continue counting.

=IF(COUNTIFS(G:G,"<>1",G:G,"<>3",G:G,"<>")<>0,0,IFERROR(INT(MATCH(0,INDEX(--($G2:INDEX(G:G,COUNT(G:G))<>$G1:INDEX(G:G,COUNT(G:G)-1)),N(IF(1,COUNT(G:G)-ROW(INDIRECT("1:"&COUNT(G:G)-1))))),)/2),INT(COUNT(G:G)/2)))

i need your help please!!thanks