View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default How many 'unique' customers has everyone been involved with?

Hello,

Or array-enter into a sufficiently long area with 2 columns:
=Pfreq(Pfreq(A1:A20,B1:B20))

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

Regards,
Bernd