frequency table

[Omar]

Dear all
I have a list of 10 employee names some names are appears more than on
time in the list. Can MS Excel create a frequency table or any kind of
table which shows the name of the employee and the frequency of each
name.
Regards

 

[Lynz]

Dear all
I have a list of 10 employee names some names are appears more than on
time in the list. Can MS Excel create a frequency table or any kind of
table which shows the name of the employee and the frequency of each
name.
Regards

Would COUNTIF work for you?

 

[Max]

A pivot will deliver it for you in seconds. Create a pivot, in Layout,
just drag n drop the col header for the employee names into both the
ROW and DATA areas. That's it. Go to the pivot sheet, you'd get the
list of unique names in one col, and adjacent to it the corresponding
counts of each name

 

[Bob Flanagan]

A pivot will deliver it for you in seconds. Create a pivot, in Layout,
just drag n drop the col header for the employee names into both the
ROW and DATA areas. That's it. Go to the pivot sheet, you'd get the
list of unique names in one col, and adjacent to it the corresponding
counts of each name



- Show quoted text -

Omar, if you want to avoid pivot tables, take a look at the Unique
Extractor product at http://www.add-ins.com/unique_extractor.htm

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[James Ravenswood]

Dear all
I have a list of 10 employee names some names are appears more than on
time in the list. Can MS Excel create a frequency table or any kind of
table which shows the name of the employee and the frequency of each
name.
Regards

If your list is in column B, then in C1 enter:
=COUNTIF(B:B,B1)

and in C2 enter:
=IF(COUNTIF($B$1:B1,B2)>0,"",COUNTIF(B:B,B2)) and copy down.