Hi Bernad,

I tried to use the formula below, however it is not working.

=Pstat("count",ISNUMBER(INDEX(Pfreq(A1:A12,B1:B12) ,2)),Pfreq(A1:A12,B1:B12))

The result I get is #NAME?.

Best Regards,

Vanessa



"Bernd P" wrote:

Hello,

Do you really want to use SUMPRODUCT, being forced to manually
maintain a list of unique names? IMHO SUMPRODUCT has become the
biggest time-waster for all Excel newbies who managed to understand
its functionality: http://sulprobil.com/html/sumproduct.html

I suggest to select an area of some rows and two columns and to array-
enter:
=Pstat("count",ISNUMBER(INDEX(Pfreq(A1:A13,B1:B13) ,,2)),Pfreq
(A1:A13,B1:B13))

[Of course you might want to use a temporary area where you evaluate
Pfreq() only once if you have thousand rows.]

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

Pstat is he
http://sulprobil.com/html/pstat.html

Regards,
Bernd