Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many times same names appear in a column
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many times same names appear in a column
Check out the XL help file article:
"Count unique values among duplicates " You can do this via filters or functions, your choice. For your example, it looks like you will need something like: =SUM(IF(FREQUENCY(IF(LEN(A2:A10)0,MATCH(A2:A10,A2 :A10,0),""), IF(LEN(A2:A10)0,MATCH(A2:A10,A2:A10,0),""))0,1)) Note that this is an array formula, and must be confirmed using Ctrl+Shift+Enter, not just Enter. -- Best Regards, Luke M "HP" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
count how many times same names appear in a column
Use the following array formula:
=sum(1/Countif(RangeOfCells,RangeOfCells)) confirm the formula with Ctrl +Shift+Enter instead of just the Enter key "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? |
#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? |
Reply |
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 |