Repetition numbers pairs >= 2

[febausa]

Please help me and recommend me the appropriate excel formula

I made the example hand made, see the file dropbox

repetition numbers pair two times or more.

https://www.dropbox.com/s/mqg4qhfotwjva0h/repetition numbers pair.xlsx?dl=0

 

[Nebu]

Hi:

Find the attached.

=SUMPRODUCT(--(MMULT(--ISNUMBER(SEARCH(J2:K2,$H$2:$H$8)),{1;1})=2))

Thanks

 

[febausa]

Hi:

Find the attached.

=SUMPRODUCT(--(MMULT(--ISNUMBER(SEARCH(J2:K2,$H$2:$H$8)),{1;1})=2))

Thanks

Hi Nebu:

I have not had success using its formula.

Please, explain more: How use your formula ?

Thank you for your help.

 

[febausa]

I need assistance with this formula:

=SUMPRODUCT(--(MMULT(--ISNUMBER(SEARCH(J2:K2,$H$2:$H$8)),{1;1})=2))

Thank you

 

[Nebu]

Hi:

What kind of assistance you want with the formula is the formula not working for you?

Thanks

 

[febausa]

Hi:

What kind of assistance you want with the formula is the formula not working for you?

Thanks

Hi Nebu:

I need help for use your formula, I want apply your formula in my case. I don't evaluate your formula.

Thank you

 

[febausa]

Hi Nebu:

I don't know to use your formula in my example. I like your formula but I don't know to use your formula.

See the example: https://www.dropbox.com/s/z2m6au03yt69xxx/repetition numbers pair-2.xlsx?dl=0

Thank you for your time

 

[Nebu]

Hi:

The file you have attached is the same file. Anyways I have constructed the formula once more and have give some explanation in the file.

Thanks