I like to refer to George Simms' example when using
FREQUENCY to count unique values based on 1 or more
criteria:
http://groups-
beta.google.com/group/microsoft.public.excel.worksheet.fun
ctions/msg/6627f4f1c7554164
HTH
Jason
Atlanta, GA
-----Original Message-----
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
.