Hi Ron,

Look at this then and tell me how I could get the report desired without
explictly naming each cell reference or actual name? My column 5800 cells
with multiple and single entries.

Unique Names Names used
Daniel Daniel, Celia
Celia Daniel
Sherlock Batman,Sherlock
Batman Daniel
Celia

Report then would be:
Daniel 3
Celia 2
Batman 1
Sherlock 1


"Ron Coderre" wrote:


If you already have a list of the unique values, an amended version of the
formula I posted would return the count of cells that contain that value.

Example:
E2: PROVIDER_SPELLS
The count of cells containing that value
F2: =COUNTIF(A:A,"*"&E2&"*")

E3: PROF_CARER_EPISODES
The count of cells containing that value
F3: =COUNTIF(A:A,"*"&E3&"*")

If you need something else, though....perhaps you could give a small example
of the source data and the structure of the final table.

***********
Regards,
Ron

XL2002, WinXP


"Daniel_ITSM" wrote:

Hi Ron,

I do have another coumn that shows the unique entries,but then how do I get
a count of Provider Speels without having to enter a hundred formulas?

Thanks!

"Ron Coderre" wrote:

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?