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
Thank you
Kim