| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting number of times a value occurs
Assuming you have only the names column (Col A) then enter this in B1 and
copy down =COUNTIF(A:A,A1) Altenatively enter 1 against each name in Col B. Then create PIVOTTABLE using A:B as range It will give you the count Let me know how it goes.... "da" wrote: How can I calculate the number of times same name appears in list of 400 names? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Count the number of times a value occurs within a dt range | Excel Worksheet Functions | |||
| I want to see how many times each number occurs in an array. | Excel Discussion (Misc queries) | |||
| Counting the number of times more than 1 variable occurs | Excel Discussion (Misc queries) | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
| How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
Threaded Mode
