Thread: How to do summation of unique counts based on another variable?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default How to do summation of unique counts based on another variable?
Hello Chin,

Select a sufficiently long range with 2 colums and array-enter:
=Pfreq(Pfreq(B1:B999,A1:A999))


Pfreq you can find he
http://sulprobil.com/html/pfreq.html


Regards,
Bernd

PS: Please do not cross post.
Reply With QuoteReply With Quote