Comparing Cells

[CDaviess]

I have a large workbook and the data within in needs to be filtered, I have datestamps in column A, these then need to be checked over all of coulmn A to see if there are any duplicates, if there are that duplicate then needs to be check against a value in column D, coulmn D contains a value either 1 or 2. if there is the same datestamp then the data stamp with a 2 in column D needs to be copied, if both contain a 2 then i just need 1 of them and if both cells contain a 1 it doesnt need to be considered.
all data from rows A & D need to be copied and placed in a new worksheet, the copied data needs to include datestamps that are not doubled and all the datestamps thathave been filtered.

Cheer

 

[CDaviess]

I have a large workbook and the data within in needs to be filtered, I have datestamps in column A, these then need to be checked over all of coulmn A to see if there are any duplicates, if there are that duplicate then needs to be check against a value in column D, coulmn D contains a value either 1 or 2. if there is the same datestamp then the data stamp with a 2 in column D needs to be copied, if both contain a 2 then i just need 1 of them and if both cells contain a 1 it doesnt need to be considered.
all data from rows A & D need to be copied and placed in a new worksheet, the copied data needs to include datestamps that are not doubled and all the datestamps thathave been filtered.

Cheer

Small change, Columns with duplicate times and a value of 1 aren't to be deleted but moved into a separate table

 

[CDaviess]

Here is a small snippet