Need formula to count number of repitatives based on criteria

[Syedali]

Hi,

PFA. I have shared file with required answers. Kindly advice on this.

 

[salim hasan]

Try this file

 

[Syedali]

Try this file

No this not correct answer.

if you see in excel sheet. 91 code is in 3 times rate also 3 times.

but 92 code is in 2 times but rate is only 1 unique values.

you modified my question itself?....

 

[salim hasan]

This is another similar file with more Option( Until row 100)

 

[Syedali]

This is another similar file with more Option( Until row 100)

NO... What you are doing that's correct . But you see my file 92 code have 2 rates but unique is 1 only so it is duplicate. 92 code having 1 value only.

 

[John Jairo V]

Hi, @Syedali!

Is this what you want? Blessings!

 

[p45cal]

Why have you got 2 entries in the reults table for code 95?:

 

[Syedali]

NO... What you are doing that's correct . But you see my file 92 code have 2 rates but unique is 1 only so it is duplicate. 92 code having 1 value only.

Hi, @Syedali!

Is this what you want? Blessings!

Thanks, This is what am looking for.


thread (closed)