Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Unique Entries
Hi all,
Column D contains staff members names. I would like to be able to count the number of times each member was listed. For example, if column D is as follows: D Smith David Smith Roberts Baker Smith I would like to get the following result: Employee 'Smith' listed '3' times Employee 'David' listed '1' time, etc. Because i don't have a pre-identified list of employees, i can't use the formula: =COUNTIF(D:D,"=Smith") Is there a formula that can: - Display the Unique Values and - the number of times each one of them appeared I use Excel 2003 Many thanks in advance Tendresse |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique entries with criteria | Excel Discussion (Misc queries) | |||
Counting unique entries | Excel Discussion (Misc queries) | |||
Counting unique entries based on given condition | Excel Discussion (Misc queries) | |||
Counting Unique Entries | Excel Discussion (Misc queries) | |||
counting unique entries in a list | Excel Discussion (Misc queries) |