View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Counting instances of Specific column entry combinations

Hi,

Am Thu, 10 May 2012 14:48:38 +0000 schrieb bryang:

Member A Certification 1
Member A Certification 2
Member A Certification 3
Member B Certification 1
Member B Certification 3
Member C Certification 2
Member C Certification 3
Member C Certification 4

So, in the above example, member A bought certification combination
(1,2,3), member b bought combination (1,3) and member C bought
combination (2,3,4). Thus, Iif I were counting the different
combinations, I'd have one for (1,2,3), 1 for (1,3) and 1 for (2,3,4) -
basically I need a total of each of the combinations purchased.


try it with pivottable


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2