View Single Post
  #1   Report Post  
Sergio
 
Posts: n/a
Default Using FREQUENCY Function to Count

I am trying to count unique values in data per the sample below. The values
I want should be per "Name"

Name Val1 Val2
Alpha 100 250
Alpha 100 350
Alpha 200 250
Beta 100 150
Beta 200 150

I would to see the following frequency values:
Name #Unique Val1 #Unique Val2
Alpha 2 2
Beta 2 1

I am not sure if I can nest one unique count in another so if not, then
perhaps separate but nonetheless per name.

Thanks