| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count text occurences in a column
I am not proficient with Excel. My challenge is to find out how many times a
term is used in a very long column. PROF_CARER_EPISODES PROF_CARER_EPISODES, PROVIDER_SPELLS CASENOTES PROVIDER_SPELLS SYSTEM_PROFILES LETTER_CONFIGURATIONS SERVICE_POINT_STAYS LDD_LOCAL_DATAVALUES WAITING_LIST_HISTORIES PROF_CARER_EPISODES PROF_CARER_EPISODES PROF_CARER_EPISODES, SERVICE_POINT_STAYS LDD_LOCAL_DATAVALUES LDD_LOCAL_DATAVALUES DIAGNOSIS_PROCEDURES ADDRESS_ROLES ADDRESS_ROLES PROF_CARER_EPISODES PATIENTS PROVIDER_SPELLS, SERVICE_POINT_STAYS Since some cells have more than one value, how can I break them out to count how many occurences there are? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the # of unique occurences of a text in a column? | Excel Worksheet Functions | |||
| Count # of Occurences | Excel Discussion (Misc queries) | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| Count occurences between dates | Excel Worksheet Functions | |||
| Count occurences between dates | Excel Worksheet Functions | |||
Threaded Mode
