hi All,

I am new in this forum, not sure if I post this correctly.

I have large data and wanted to delete duplicate rows but with conditions.

sample:
Name Result date
John Bad 1-Jan-14
Paul Good 1-Jan-14
Rick Good 1-Jan-14
John Good 3-Jan-14
Paul Bad 4-Jan-14
Linda Bad 4-Jan-14


There are duplicates, but i wanted to delete the row of data if the duplicate has a 'good' result on later date. If the later date result is 'bad', I want to delete the past good result and keep the 'bad' row.

outcome:
Name Result date
Paul Bad 4-Jan-14
Linda Bad 4-Jan-14

thank you in advance for your help