Thanks for the clarification.....I withdraw the comment. <g

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

XL2002, WinXP


"Daniel_ITSM" wrote:

I dont think I need another unique name list.
What I need is a count like you did!

"Ron Coderre" wrote:

I see by your NEW THREAD that you'd like the UniqueNames list populated
automatically from the values in the source table. While it could
conceivably be done with formulas, a VBA solution would consume a lot less
computational overhead, since the procedure would only be run on-demand. If
that is something you're interested in, let us know. Somebody may have
already created the code and would only need to re-post it , or the link, for
you.

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

XL2002, WinXP


"Ron Coderre" wrote:

With
A1:A6 containing this list
NamesUsed
Daniel, Celia
Daniel
Batman, Sherlock
Daniel
Celia

AND....
E1:F5 containing this list
UniqueNames Counts
Daniel
Celia
Batman
Sherlock


THEN.....
These formula return the desired counts:
F2: =COUNTIF(A:A,"*"&E2&"*")
Copy that formula down through F5

This is the result set:
UniqueNames Counts
Daniel 3
Celia 2
Batman 1
Sherlock 1


Now....if you wanted those value in a report, perhaps you could employ a
Pivot Table with UniqueNames as the ROW value and Sum of Counts in the DATA
section. That way you could filter out names with zero counts, etc.

(Post back if you have more questions)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Daniel_ITSM" wrote:

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?