Removing Duplicates Complication

Hi there,

I have a list of data in the following format and need to remove duplicates. An example is below:

ID: Status:
abc123 True
abc123 True
abc123 False
DFG123 True
DFG123 False
DFG123 True
QWE456 True
QWE456 True

So what I need is to remove all the duplicates from ID across the data set but in situations where there is a false within the status, I need to keep that and remove the trues. Example the first ID "abc123", I need to remove the two with true and leave the false. Whereas other duplicate ID's with only a True status, I'd just need to remove the dupes as per normal.

Appreciate any help!

Thanks,
Mike

Try the example

Macro consists in 3 basic sections

Sort the data with column A and then column B (taking advantage that FALSE precedes TRUE)

Clear the output area columns D & E

Test each row for duplicates and only write it in column D if unique

Thanks to all 3 of you!! Amazing help, appreciate it