# detect only the initial pair of each of the 4 groups.

#### jack

##### Member
detect only the initial pair of each of the 4 groups,
note that is only the first two numbers
of each sector, goal is to find the beginning of each of the 4 patterns (groups)

#### Frank

##### Member
detect only the initial pair of each of the 4 groups,
note that is only the first two numbers
of each sector, goal is to find the beginning of each of the 4 patterns (groups)
Cell Q6=IF(COUNTIF(\$P66,"x")<2,IF(ISNA(MATCH(Q\$5,\$A6:\$O6,0)),"","x"),"") then copy formula across to W6

Cell Y6=IF(COUNTIF(\$X6:X6,"x")<2,IF(ISNA(MATCH(Y\$5,\$A6:\$O6,0)),"","x"),"") then copy formula across to AC6

Cell AN6=IF(COUNTIF(\$AM6:AM6,"x")<2,IF(ISNA(MATCH(AN\$5,\$A6:\$O6,0)),"","x"),"") then copy formula across to AR6

Then copy whole range Q6:AR6 down the spreadsheet as far as you need.

#### jack

##### Member
FRANK! thanks for the hard work, we have to translate the formulas to portuguese, my excel is in portuguese

#### Frank

##### Member
FRANK! thanks for the hard work, we have to translate the formulas to portuguese, my excel is in portuguese
I have given you a conversion table more than once. Off you go- get on with it!

#### jack

##### Member
ok you're correct congratulations thanks frank