0

I want to delete duplicates in excel sheet while comparing second column in sheet. I have an excel sheet with two columns A and B, while values repeat in both columns but i only want to remove values in column B which is appearing again against same value of column A. For example:

 A    B
ABC  DEF  
ABC  GHI
ABC  DEF
QWE  DEF
QWE  IKI
QWE  DEF

---> want to remove DEF duplicate value against ABC and QWE, DEF should appear once against ABC and QWE.

  • 2
    Welcome to Super User, your post needs some illustration for better understanding!! – Rajesh S Apr 15 at 6:30
  • 1
    Select the data, then go to the Data tab, Remove Duplicates – cybernetic.nomad Apr 15 at 10:56
0

Select 2 Columns- go to Data- Remove Duplicates:

enter image description here

  • Thanks for sharing, it worked as per my requirement :-) – Salman Ahmad Apr 17 at 8:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.