Question on duplicate rows tutorials.

Hi, I was looking at https://www.extendoffice.com/documents/excel/3421-excel-delete-rows-based-on-duplicates-in-one-column.html  and https://www.extendoffice.com/documents/excel/3202-excel-remove-duplicates-keep-highest-value.html       Can I use either of these to find duplicates in one column and only delete the rows using values from another column?  Example: In this case only rows 8 and 9 would be deleted because they are duplicates and the newest by date or top duplicate is PASS. 

 


 Thank you
Kim