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?
|