(Solved) – Get unique count combining two columns in Excel VBA

  • by
(solved)-–-get-unique-count-combining-two-columns-in-excel-vba

I have an excel with columns

ID|Gender|Age|Center
1    M     20  Center1
1    M     24  Center1
2    M     25  Center2
3    F     30  Center2 
4    F     25  Center1

Total Males -   2   Total Males in Center1 - 1 
Total Females - 2   Total Females in Center2 - 1 

I want to count the unique combination of Id and Gender. Also, the same info required as center-wise.

Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *