Thread: Duplicates by groups
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Duplicates by groups
Hello Walter,

Select a sufficiently long area with 3 columns and array-enter:
=Pfreq(A1:A999,B1:B999,C1:C999)

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

Regards.
Bernd
Reply With QuoteReply With Quote