View Single Post
  #4   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 (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?