frequency table
On Mar 2, 4:49*am, Omar wrote:
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.
|