Dear All,
I am beginner of VBA, I wanna create a VBA that can remove deplicate rows if column A as duplicate and referring to Column B value.
For instance, pic. 1 is raw data, pic. 2 is the results that I wanted.
From pic.1 , there are 4 duplicate groups (ABC123, AD12, AA12, mm).
2 things I...