| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting of names
Hi,
It looks from your example as if both names could appear in the same cell so try this for John with the obvious change for Pete. Note this isn't case sensitive and its and array so enter with CTRL+Shift+Enter =COUNT(SEARCH("john",A1:A25,1)) Mike "ekkeindoha" wrote: Good day, I would like to count names automaticly for instance, A B John & Pete 2 John 1 If somone can help with a formula Thx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting unique names - again | Excel Worksheet Functions | |||
| counting names | Excel Worksheet Functions | |||
| counting names only once in a list | Excel Worksheet Functions | |||
| Counting Names in a List | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Threaded Mode
