| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting occurance of a name in a cell
Hi,
I have a column that will have names, which can be repeated any no of times. for example in column A data is as below. alex alex edward david jim david edward jim david I want to know how many times jim was repeated. The result i am looking for is like below col B col C alex 2 david 3 edward 2 jim 2 Can anybody tell me how to do this using functions. If I need to write any macro how do I. Thank you, sri k. .. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting occurance of a name in a cell
Answered in worksheet.functions
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) wrote in message ... Hi, I have a column that will have names, which can be repeated any no of times. for example in column A data is as below. alex alex edward david jim david edward jim david I want to know how many times jim was repeated. The result i am looking for is like below col B col C alex 2 david 3 edward 2 jim 2 Can anybody tell me how to do this using functions. If I need to write any macro how do I. Thank you, sri k. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting occurance of empty cells | Excel Discussion (Misc queries) | |||
| Counting occurance of 0 in two columns | Excel Worksheet Functions | |||
| Counting the Excced occurance... | Excel Discussion (Misc queries) | |||
| Occurance Counting | Excel Worksheet Functions | |||
| Counting occurance of letters or numbers | Excel Discussion (Misc queries) | |||
![Bob Phillips[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
