Search : in
By :

How to count multiple instances in single cel

Last answer on Nov 17, 2009 7:50:55 am GMT Tony, on May 1, 2009 7:33:37 pm BST 
 Report this message to moderators

Hello,

I need to count to number of text strings within a single cell:

| Marketing;Proposals & Presentations;;| Marketing;Promotional Print;;| Public Relations;Advertising;;| Public Relations;Branding;;| Public Relations;Visual Identity;;

this is inside a single cell in a single column. It cannot be edited.

I was to count the number "Public Relations".
Using countif(A1,"*Public Relations*") only returns 1.
The data in each row of this column is different, the next row may not have any Public Relations in it...

any ideas?

Configuration: Windows Vista Internet Explorer 7.0

Best answers for « How to count multiple instances in single cel » in :
Multiplayer not working Show
Call of Duty 4 Multiplayer dont open Show
Data transmission - Multiplexing Show Introduction to multiplexing Multiplexing refers to the ability to transmit data coming from several pairs of equipment (transmitters and receivers) called low-speed channels on a single physical medium (called the high-speed channel). A...
Connecting to multiple monitors ShowConnecting to multiple monitors Under windows, it is possible to connect multiple monitors enabling simultaneous displays in view to extend the office size and rely on a larger working area. To proceed with this feasibility, it...
Renaming multiple files in batch ShowRenaming multiple files in batch Native features Using a third-party program Renaming a large number of files can quickly become tedious. Fortunately, there are tools to automate this task in many cases: Native features On Windows...
Expand your Desktop over multiple monitors ShowExpand your Desktop over multiple monitors Hardware Requirements Software Requirements How to proceed If you are using Windows and want to enlarge your current desktop without having to buy another huge screen, this is possible by...
Download My MultiPlayer Show
Download Multiple File Search and Replace Show
Download Multiply Toolbar ShowThe sharing of data, including media is most often through the Internet. The best known is sent by mail, but now there are more simple. Multiply Toolbar is a Firefox extension that lets you share any type of media with all the people you know. This...
Object class and instance ShowThe concept of classes A class is the structure of an object, meaning the definition of all items that an object is made up of. An object is therefore the "result" of a class. In reality, an object is an instance of a class, which is why can use...
Binary encoding ShowIntroduction to binary In the late 1930s, Claude Shannon showed that by using switches which were closed for "true" and open for "false," it was possible to carry out logical operations by assigning the number 1 to "true" and 0 for "false." This...
Ask your question Reply

1

mubashir aziz, on May 6, 2009 5:54:25 am BST

Your explanations are not enough for me but as per my understanding .......

Suppose you have data in Column A from A2 to A50 then in any cell except A you can write below formula which will count public relations in column A .......

=COUNTIF(A2:A50,"Public Relations")




Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran

   
Reply to mubashir aziz

2

 Ramu Gurrapu, on Nov 17, 2009 7:50:55 am GMT

Aziz,

Question here is not to count in columns but to count in the cell

for ex in A1 cell if i have the data "TDR1, TDR2, TDR3" i want to get the count of it... the answer should be "3" which is count of TDR......

any guess now ??? :)

   
Reply to Ramu Gurrapu
Ask your question Reply
They need your help