Identifying Duplicate Identifiers based on 3 conditions

Masond3

Good Morning Team, 

Looking for some help, 

Trying to create some logic to identify duplicates identifiers (Column D)  based on a combination of 3 Columns

I have created the following matrix that hopefully articulates the problem 

1. First of all i want to identify duplicate identifiers(column D) where the internal id ( column A) is the same
   1. From here i would then use the Privacy to determine the outcome 
2. Next Step  would be to identify duplicate identifiers(column D) where the internal id ( column A) is not the same
   1. then use the privacy to determine the outcome
       

      internal ID	Privacy	Identifier	Duplicate	Scenario
      MASOCE6GnHH63gvL8qFeL	Public	11111	Yes	1
      MASOCE6GnHH63gvL8qFeL	Public	11111
      MASOCE6GnHH63gvL8qFeL	Public	11111	No	1
      MASOCE6GnHH63gvL8qFeL	Private	11111
      CDMCE6GnHH63gvL8qFeL	Private	11111	No	1
      CDMCE6GnHH63gvL8qFeL	Private	11111
      MASOC7xsHXZubkvfWlNf0	Public	11111	Yes	2
      MASOCLEPKXEZVJHAQhlxs	Public	11111
      MASOC7xsHXZubkvfWlNf0	Public	11111	Yes	2
      MASOCLEPKXEZVJHAQhlxs	Private	11111
      MASOC7xsHXZubkvfWlNf0	Private	11111	Yes	2
      MASOCLEPKXEZVJHAQhlxs	Private	11111

aatalai

use the unique tool and select the relevant fields would that work?