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

 

[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.

 

[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

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