Hi,
Given the data below:
Expected 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
Hello Tan,
If ID_Type in your production data has limited types, try this.
Regards
Lei