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

On 2/03/2011 10:49 p.m., 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

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

On Mar 2, 5:49*pm, 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

On Mar 3, 8:08*am, Max wrote:
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

On Mar 2, 5:49*pm, 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- Hide quoted text -

- 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

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.