Skip to main content

Hi,

 

Given the data below:

Count records base on combination value from same column

Expected result :

result

 

As you can see from above, i need to find the possible conbination that the same ID_NO have, example, ID_NO 1234 have ID_TYPE 1 & 2, so i need to count it as 1. The ID_NO "4567" and "4321" both have the ID Type conbination 1 & 4, henace 1 & 4 count is 2.

 

I have totaly no idea how to do this, kindly assist.

 

Regards,

Chee Ho

3 answers
0/9000