Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or
×

file Question on duplicate rows tutorials.

More
10 months 5 days ago - 10 months 5 days ago #3192 by Kimber
Hi, I was looking at How to delete rows based on duplicates in one column in Excel?  and How to remove duplicate rows and keep highest values only in Excel?       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
Attachments:
Last edit: 10 months 5 days ago by Kimber.

Please Log in or Create an account to join the conversation.

Moderators: ExcelfansOfficeFansAmanda Lee