Hi Ron: Thank you for your expertise...I was trying a Pivot Table on my own
but wasn't having much luck....I used your instructions and it works
PERFECTLY. Thank you. I also tried Ragdyer's solution, but I prefer the
Pivot Table that you recommended. Thank you again.
--
jeannie v


"Ron Coderre" wrote:

Try a Pivot Table:

Assuming the names are in A1:A100
with A1: AGENT

From the Excel Main Menu: <Data<Pivot Table
Use: Excel..Click [Next]
Select A1:A100..Click [Next]
Click the [Layout] button

ROW: Drag the AGENT field here
COLUMN: (leave this area blank)
DATA: Drag the AGENT field here,too
If it doesn't list as Count of AGENT...dbl-click it and set it to Count
Click [OK]
Select where you want the Pivot Table.Click [Finish].

That will list each AGENT and the count of AGENT.

To refresh the Pivot Table, just right click it and select Refresh Data

Pivot Table Links:
http://www.nickhodge.co.uk/gui/datam...ablereport.htm
http://www.contextures.com/tiptech.html


Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"jeannie v" wrote in message
...
Hello Experts:

I have several names posted several times in Column A and which will
change
from day to day. How can I count all occurences of each name in Column A
each day. The agents will never be in the same cells and the names of the
agents will change each day. Can anyone give me direction? Thank you as
always,
--
jeannie v