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