| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count of text in cells
I have problem to solve,I have a column with office. The text in the Office cells with be, Office 1@810@NT but I now have a new columm with text in the following format:Test The Cell - Employment cells can contain mutiple values, Test The Cell - Education;Test The Cell - Employment;Test The Cell - Health
. These values are separated by a ; NOt only do I need to count each occurance, but I then need to have a count of each one. I can have these values referred to in a cell if that makes it easier. Sorry if I have not been clear Submitted via EggHeadCafe - Software Developer Portal of Choice The SQLite Database Engine and ADO.NET Provider http://www.eggheadcafe.com/tutorials...ase-engin.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count blank cells and cells with text | Excel Discussion (Misc queries) | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| How do I count cells with text but ignore cells with spaces? | Excel Discussion (Misc queries) | |||
| count cells containing text | Excel Worksheet Functions | |||
| Count Cells containing Text only | Excel Programming | |||
Threaded Mode
