Hi,
I working with Excel 2007 and would like to remove duplicates in column D, but keep the first instant.
It has to look at column A for duplicates then look at column D and remove all the duplicates, but the first one.
I need to keep the data in the other columns (A, B, C, E ...)

Original Data
Column A Column D
CH010 DUE FROM MANAGEMENT
CH010 DUE FROM MANAGEMENT
CH010 DUE FROM MANAGEMENT
CH010 SAMMY MANAGEMENT
CH010 SAMMY MANAGEMENT
CH010 AIDAN MANAGEMENT
CH010 AIDAN MANAGEMENT
CM03 SECURE MESSAGING
CM05 SECURE MESSAGING
CM05 SAFE MESSAGING
NIM010 WEAS MODEL
XAP010 OPEN FINANCIAL
XAP010 OPEN FINANCIAL
XAP010 CLOSE FINANCIAL
XAP010 CLOSE FINANCIAL



Should look like:

Column A Column D
CH010 DUE FROM MANAGEMENT
CH010
CH010
CH010 SAMMY MANAGEMENT
CH010
CH010 AIDAN MANAGEMENT
CH010
CM03 SECURE MESSAGING
CM05 SECURE MESSAGING
CM05 SAFE MESSAGING
NIM010 WEAS MODEL
XAP010 OPEN FINANCIAL
XAP010
XAP010 CLOSE FINANCIAL
XAP010


Thanks