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
Bookmarks