frequency table

  • Thread starter Thread starter Omar
  • Start date Start date
O

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
 
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?
 
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
 
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
 
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.
 
Back
Top