Please help me with deleting the duplicates with preferences

[Sai Prasad]

Hi,

I have a scan results which projects duplicate values as listed in the attachment.

Columns A (Machine Names) are listed with duplicates and Column D has the Application listed. In Column E (Purchase date) has pulled up one entry with a scan date and the other with a blank.

I am looking at Column A and D duplicate value which needs to be deleted with only one entry from Purchase date data reflecting in the file.

Please help.

Regards,
Sai.

 

[Asheesh]

Hi Sai -

Attachment is missing..

 

[Sai Prasad]

Attachment

 

[Sai Prasad]

Just a sec.....I am unable to upload the attachment...let me check

 

[Sai Prasad]

.

 

[srinidhi]

for A & D apply the conditional format (highlight duplicate value) separately. Filter the blanks in column E & delete the highlighted cells in A & D.
Please upload the file it this is not what you are looking for.