Forum Discussion
Solved
How to find duplicate values in one column while another column has different values?
Hi all I need help to find the the rows in 'green' shown below. Controller_Node_Id BarCode Merged Column 10963 100 10963100 10961 100 10961100 10963 200 10963200 10963 20...
hey JonKho is there a possible scenario where there is a valid one row per combination of controller nod and bar code or will all valid combination have matching duplicate values?
There will be a chance where it will has additional duplicate rows like the one below shown below.
Controller_Node_Id BarCode 10963 100 10961 100 10963 100 10961 100 10963 200 10963 200 10961 300 10961 300 However, I want to find a way to detect the two green rows that is shown below like I mentioned in my first post.
Controller_Node_Id BarCode 10963 100 10961 100 10963 200 10963 200 10961 300 10961 300 Thank you.
