View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
WalterAndersen WalterAndersen is offline
external usenet poster
 
Posts: 3
Default Duplicates by groups

Bernd - thanks for the info.

I am getting an error when I run the fomula. Any ideas? The error is
"#NAME?".

"Bernd P" wrote:

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
.