View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chuck Chuck is offline
external usenet poster
 
Posts: 90
Default Counting unique values with criteria

I need to count the number of unique cases given certain criteria. For
example,

Case # Code
3356 Stroke
3356 Stroke
3357 Cancer
3357 Cancer
3356 Cancer
The results should indicate: 1 unique case for Stroke; 2 unique cases for
Cancer. Thanks for any help.