子集重复值具有两个不同的状态值

I have Id Values some are duplicates, there is another column Status (yes/No) , I want to extract the subset of duplicate values which have two different status values. For example , if my dataset is as belowI have Id Values some are duplicates, there is