Expl. I want to know how many times the number 23 left with the number 15> ex 15 along with 23 left 1 time together



Expl. I wonder how many times the number 23 left with the number 96> ex 15 along with 96 left 1 time together

Expl. I wonder how many times the number 71 left with the number 96> ex 15 along with 71 left 1 time together

So successively

And that I have 5 thousands from the 1st to the 5th prize, but in each award can repeat the draw of the ten in each prize Because each prize is drawn ten of 01 oo or better 100 would like to know how to count only 2 certain value Among the five prizes more There can be a draw of ten duplicates so I need a formula for the specific case on top 1 and the 100 or 00 and so on
Assinar
01323 23
53015 15
32796 96
72271 71
57902 02


Tipo de Alteração



0




Expl. quero saber quantas vezes o número 23 saiu com o número 15 >ex 15 junto com 23 saiu 1 vez junto

Expl. quero saber quantas vezes o número 23 saiu com o número 96 >ex 15 junto com 96 saiu 1 vez junto

Expl. quero saber quantas vezes o número 71 saiu com o número 96 >ex 15 junto com 71 saiu 1 vez junto

Assim sucessivamente
E que tenho 5 milhares do 1º ao 5º prêmio, mas em cada premiação pode repetir o sorteio das dez em cada premio Pois cada prêmio é sorteado dez de 01 oo ou melhor 100 gostaria de saber como contar só 2 determinado valor Entre os cinco prêmios mas pode ocorrer sorteio de dez duplicada por isso preciso de uma formula para o caso específico em cima 1 e o 100 ou 00 e assim sucessível
01323 23
53015 15
32796 96
72271 71
57902 02

I don't understand what you want.

Please give examples of expected results.

I would like to know how to make a formula in excel to count how many times you two numbers or three numbers will go together

Example: in a lottery draw
Let's imagine that I have 100 sz to draw 5 dz
I want to know how many times you look every ten years, with a dozen others.
Example the dz 01 was spelled 50 times
Only that in this lottery this ten number 01 was drawn along with the number 10
(15) times
How to make a formula to gauge how many times these two dozen will leave together thanks

I regret, but I will have to withdraw from this discussion as I still have no idea what it is all about.