How to delete duplicates?

Hi, we have a list of data that has duplicate information in Column A. Now we want to remove the duplicates and just leave the word that has the highest number in column C and the lowest number in Column D but there are instances where column C or D maybe the same.

Please check the image below. So for the case of “Rose”, we just want to leave the first “Rose” with the highest number in column C and Lowest number in Column D and filter out the other “Rose” on the list.

image