Obtener cantidad de números repetidos en una sol celda de excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1286629%22%20slang%3D%22es-ES%22%3EGet%20number%20of%20repeated%20numbers%20in%20a%20sun%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1286629%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20day%2C%20I%20want%20to%20apply%20a%20statistical%20independence%20technique%20called%20%22poker%20test%22%2C%20so%20I%20need%20to%20get%20the%20frequency%20with%20which%20the%20numbers%20are%20repeated%20in%20each%20of%20the%20excel%20cells%2C%20I%20would%20like%20someone%20to%20indicate%20to%20me%20how%20I%20should%20formulate%20or%20what%20function%20I%20can%20use.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EI%20have%20the%20number%200.12241%20here%20I%20want%20to%20know%20how%20many%20times%20each%20digit%20is%20repeated%2C%20for%20this%20case%20it%20is%20repeated%20once%20the%20number%201%20and%20once%20the%20number%202%2C%20which%20formula%20I%20can%20use%20to%20make%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1286629%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1287697%22%20slang%3D%22en-US%22%3ERe%3A%20Obtener%20cantidad%20de%20n%C3%BAmeros%20repetidos%20en%20una%20sol%20celda%20de%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1287697%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F611799%22%20target%3D%22_blank%22%3E%40WilliamDC%3C%2FA%3E%26nbsp%3BI%20made%20an%20example%20in%20the%20attached%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Buen día, deseo aplicar una técnica de independencia estadística llamada "prueba póker", por lo que necesito obtener la frecuenaci con la cual se repite los números en cada una de la celdas de excel, quisiera por favor alguien me indique como debo formular o que función puedo utilizar.

 

Ejemplo:

tengo el número 0,12241 de aquí deseo saber cuantas veces se repite cada dígito, para este caso se repite una vez el número 1 y una vez el número 2, que fórmula puedo utilizar para hecer esto.

 

 

Muchas gracias...

1 Reply
Highlighted

@WilliamDC I made an example in the attached workbook.