Hello,
I am looking some help in getting distinct count by criteria. For example if you refer the below table I brought the distrinct count by using formala {=Sum(1/Countif(A:A,A2))} however, in additon to this need another conditional criteria. If given % different for no then it should consider as 1 count and if more than 1 then it should go for 1/count.
I have mentioned the final require results. can anyone will help on this requirement.
<colgroup><col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> </colgroup><tbody>
</tbody>
I am looking some help in getting distinct count by criteria. For example if you refer the below table I brought the distrinct count by using formala {=Sum(1/Countif(A:A,A2))} however, in additon to this need another conditional criteria. If given % different for no then it should consider as 1 count and if more than 1 then it should go for 1/count.
I have mentioned the final require results. can anyone will help on this requirement.
No | % | Distinct Count | Final Results |
1111 | 60 | 0.50 | 1.00 |
2222 | 40 | 0.50 | 1.00 |
1111 | 50 | 0.50 | 1.00 |
3333 | 10 | 1.00 | 1.00 |
4444 | 50 | 1.00 | 1.00 |
2222 | 60 | 0.50 | 1.00 |
5555 | 50 | 0.50 | 0.50 |
5555 | 50 | 0.50 | 0.50 |
6666 | 10 | 0.33 | 1.00 |
6666 | 60 | 0.33 | 1.00 |
6666 | 50 | 0.33 | 1.00 |
<colgroup><col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3730;width:77pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:3401;width:70pt" width="93"> </colgroup><tbody>
</tbody>