Thread: Count unique values across two columns with multiple conditions
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Count unique values across two columns with multiple conditions
Hello,

I suggest the array formula
=Pfreq(Pfreq(C5:C10,A5:A10,B5:B10))

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

Regards,
Bernd
Reply With QuoteReply With Quote