Required for Containing Count forumla

[Suri]

Pls let mee I want containing text count forumla


9845335566Aritel000354

9845225445Aritel000354

9825632544Docomo00065

9663441115BSNL0034

9611145245Reliance0033

7633244545Reliance0033

9333446699BSNL0034

9333454442Idia6356

9335453446Reliance3333

9324992877Vodofone043

9336574776Vodofone043

9422432399Aritel000354

9428824582Aritel000354

24885662land Line

38552245land Line

21466463land Line

42244325land Line

68724475land Line


Arite 3

BSNL 2

Docomo 1

Idia 1

land Line 5

Reliance 3

Vodofone 2


Like i want

 

[Hui]

Suri


How about something simple like:

=COUNTIFS(A1:A18,"*Aritel*")

In your example there are 4 entries with Aritel, not 3 for Arite

 

[kaushik03]

Suri,


Can you please check the file here?


https://hotfile.com/dl/169434027/9c78b56/Count_of_specific_text_from_text_string.xlsx.html


Kaushik

 

[kaushik03]

Hui,


Wow....It is amazing....


Can you you plz teach me on the implication of using * at the both end of a word?

It seems like when we specify a particular text within a text string...


Is there any other scenario (I am sure there is..) where we can use this? Just curious and wanted to learn...


Regards,

Kaushik

 

[Hui]

Kaushik


Your assumption about the use of * is correct, its called a "Wild Card" character

In some areas you can use wildcards like ? as any single character or * for any series of characters


I don't have a definitive list of where you can use wildcards like ? and *, but I know Match is happy to use them


You may want to have a read of:

http://www.myonlinetraininghub.com/excel-wildcards-in-your-sumif-countif-and-vlookup

or

http://technologytraining.psu.edu/node/303

 

[kaushik03]

Hui,


Thank you for the explanation and sharing the relevant study materials.


Regards,

Kaushik