Help me to countif unique number?

[iRasim]

Pls Help me to countif unique number, in added excel file I wrote what I wanted.

 

[Somendra Misra]

Hi Rasim,

Try below array formula, enter with Ctrl+Shift+Enter.

=SUMPRODUCT(IF(FREQUENCY(IFERROR(MATCH(IF(H8=$B$2:$B$7,$A$2:$A$7),$A$2:$A$7,0),"e"),IFERROR(MATCH(IF(H8=$B$2:$B$7,$A$2:$A$7),$A$2:$A$7,0),"e")),1,0))

Regards,

 

[Debraj]

Here is another method..

=SUM(IF(B2:B7=H8,1/COUNTIFS(C2:C7,C2:C7,B2:B7,H8)))

 

[iRasim]

You are genuie. It is interesting me how does your brain work? But mine not like you. Is not there simple way ?

 

[Somendra Misra]

@iRasim

Try pivot table as shown below.



Regards,

 

[iRasim]

Thanks a lot