@Banksy you could try and use the new duplicate row filter which would allow to specify additional conditions about which entry to use when there are identical entries (eg. sort by the ‘result’ column).
Also you could define a RANK variable for a group (your duplicates you wish to identify) with the help of SQLite or H2 in KNIME and then add the ‘Result’ as an additional sorting option.
If you just want to remove the Fails you just could use a Row Filter: