Consider using a pivot table. It can take your posted data and make:
ADDRESS_ROLES 2
CASENOTES 1
DIAGNOSIS_PROCEDURES 1
LDD_LOCAL_DATAVALUES 3
LETTER_CONFIGURATIONS 1
PATIENTS 1
PROF_CARER_EPISODES 4
PROF_CARER_EPISODES, PROVIDER_SPELLS 1
PROF_CARER_EPISODES, SERVICE_POINT_STAYS 1
PROVIDER_SPELLS 1
PROVIDER_SPELLS, SERVICE_POINT_STAYS 1
SERVICE_POINT_STAYS 1
SYSTEM_PROFILES 1
WAITING_LIST_HISTORIES 1
Grand Total 20
listing each item of text and how many times it occurs. See:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student
gsnu200709
"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?