View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MDBCT MDBCT is offline
external usenet poster
 
Posts: 2
Default 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?