SOLVED

CONTAR LA VECES QUE APARECE UN TEXTO EN UNA COLUMNA!!

%3CLINGO-SUB%20id%3D%22lingo-sub-1459999%22%20slang%3D%22es-ES%22%3ECOUNT%20THE%20TIMES%20A%20TEXT%20APPEARS%20IN%20A%20COLUMN!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459999%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20afternoon%3C%2FP%3E%3CP%3EThis%20problem%20I%20have%20in%20favor%20of%20can%20help%20me.%3C%2FP%3E%3CP%3EI%20have%20a%20column%20in%20which%20several%20texts%20appear%20separated%20by%20%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22oscarpaco_0-1592000890605.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F198478i04409AA2D5EC1DC4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22oscarpaco_0-1592000890605.png%22%20alt%3D%22oscarpaco_0-1592000890605.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eand%20I'd%20like%20to%20help%20you%20find%20a%20formula%20that%20would%20tell%20me%20how%20many%20times%20the%20texts%20appear%20in%20that%20column.%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CUL%3E%3CLI%3EShort%2C%20clear%20and%20specific%20activities%20for%20some%20content.%20(4%20times)%3C%2FLI%3E%3CLI%3EActivities%20for%20oral%20transmission%20of%20anecdotes%20and%20family%20histories%2C%20board%20games%2C%20virtual%20tours%20to%20museums%2C%20among%20others%20(5%20times)%3C%2FLI%3E%3CLI%3EActivities%20that%20students%20could%20perform%20autonomously%20(6%20times)%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIn%20advance%20thank%20you%20very%20much%20for%20the%20support!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1459999%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-1460637%22%20slang%3D%22en-US%22%3ERe%3A%20CONTAR%20LA%20VECES%20QUE%20APARECE%20UN%20TEXTO%20EN%20UNA%20COLUMNA!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460637%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697016%22%20target%3D%22_blank%22%3E%40oscarpaco%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCOUNTIF(%24B%242%3A%24B%248%2C%22*%22%26amp%3BB26%26amp%3B%22*%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1460830%22%20slang%3D%22es-ES%22%3ERe%3A%20COUNT%20THE%20TIMES%20A%20TEXT%20APPEARS%20IN%20A%20COLUMN!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460830%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20Morning%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20prompt%20response.!!%3C%2FP%3E%3CP%3EIt%20worked%20perfectly%20for%20me.%20%3CBR%20%2F%3E%20Greetings%20Cordials%20Sergei!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1460936%22%20slang%3D%22en-US%22%3ERe%3A%20CONTAR%20LA%20VECES%20QUE%20APARECE%20UN%20TEXTO%20EN%20UNA%20COLUMNA!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460936%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697016%22%20target%3D%22_blank%22%3E%40oscarpaco%3C%2FA%3E%26nbsp%3B%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Buenas Tardes,

Me podrán ayudar ésta problemática que tengo de favor.

Tengo una columna en la cual aparecen varios textos separados por ;

oscarpaco_0-1592000890605.png

y quisiera me ayudar a buscar una fórmula que me contara cuántas veces aparecen los textos en dicha columna.

Ejemplo:

  • Actividades cortas, claras y específicas para algún contenido. (4 veces)
  • Actividades para la transmisión oral de anécdotas e historias familiares, juegos de mesa, recorridos virtuales a museos, entre otras (5 veces)
  • Actividades que los alumnos pudieran realizar de manera autónoma (6 veces)

De antemano muchas gracias por el apoyo!!

5 Replies
best response confirmed by oscarpaco (Occasional Contributor)
Solution

@oscarpaco 

That could be

=COUNTIF($B$2:$B$8,"*"&B26&"*")

Buenos Días @Sergei Baklan 

Muchas Gracias por tu pronta respuesta.!!

Me funcionó a la perfección.
Saludos Cordiales Sergei!!

tenho um problema parecido, porem preciso saber quantas vezes aparece cada palavra na coluna.
ex: existe na coluna os codigos: 010D1MN, 011D2NN, 010D2BR, 010D9YT
São muitos... como eu faço para ter o seguinte resultado:
010D1MN = 10
011D2NN = 23
010D2BR = 07
010D9YT = 44

@EduCristian 

You may create PivotTable which count each unique word within the column.