count text occurences in a column
Try something like this:
With
Col_A containing various text entries or blanks
This formula returns the count cells that contain the text string:
"PROVIDER_SPELLS"
=COUNTIF(A:A,"*PROVIDER_SPELLS*")
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
"Daniel_ITSM" wrote:
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?
|