| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many times same names appear in a column
Use the following Array formula (confirm formula with Ctrl+Shift+Enter)
=sum(1/countif(RangeOfCells,Range,OfCells)) "HP" wrote: I have a column of names with patients who has blood transfusions . For example Paul Smith with appear 3 times ie he had 3 units of blood transfusion. What I need is total number of patients who has blood transfusion. The list is about 1400 cells long. Can anyone help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count how many times the same word appears in column | Excel Discussion (Misc queries) | |||
| Count the times a value appears in a column based on another value | Excel Worksheet Functions | |||
| Formula to enter names in a column specific # of times | Excel Worksheet Functions | |||
| How can I count how many times different texts repeat in a column? | New Users to Excel | |||
| How do I count how many times x appears in a column? | Excel Worksheet Functions | |||
Threaded Mode
