Compare columns and delete duplicates

Hi Gents,

Im new to this forum and need your help to resolve one requirement. I have 3 columns in a worksheet, where there are number of duplicates.

I want to some technic/Macro to eliminate those duplicate comparing 3 columns which are important. I have attached a sample data and result i need .
I sincerely hope some one will help for sure.

Thanks much,
-Eph