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 |
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 . |
All times are GMT +1. The time now is 06:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com