rjplante
Well-known Member
- Joined
- Oct 31, 2008
- Messages
- 574
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet that has three cells merged vertically. In this cell I enter six different letter codes to help me track performance instances. These are "A+", "A-", "m+", "m-", "+", and "-". Each of these are separated by a space within the cell. I would like to have six different cells off to the right to count the number of occurrences of each one inside the cell. How many "+" responses, how many "m-" responses, etc. Is there a formula that will allow me to count each item? Do I have to use commas in the cell to separate my entries? I have been searching online and trying various formula iterations, but I can't seem to find one that will do what I need.
Thanks for the help.
Thanks for the help.