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
|