Count distinct values where condition satisfy

Closed
NS - Feb 10, 2011 at 10:59 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 11, 2011 at 06:22 AM
Hello,
I a trying to count distinct values of Column B for a given value of Column A.

For example, if a number 000759BY5 (column A) had two different values in Column B; i. e 72.00% & 31.69%, then i want to populate Yes, else No

Hope I am clear. Please help.

Thx



1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 11, 2011 at 06:22 AM
At least I am not clear. You say you a count of distinct values and also you say you want to see YES or NO.

Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , [http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0