frequency table

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
 
G

guitarSevilla

You can create a table using COUNTIF.

Your list is in the range $A$1:$A$20. This is the list where
employees may appear frequently.

Your distinct list of employees starts in B1. In C1 enter this
formula:

COUNTIF($A$1:$A$20,B1)

You can then copy this down your distinct employees list.
 
R

Ron Rosenfeld

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
Click to expand...

You could use a Pivot Table. It would give you a unique list of employees, and the number of times each employee is listed.
 
Top