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.

cybernetic.nomad
  • 5,951
  • 15
  • 26
Salman Ahmad
  • 1

1 Answers1

0

Select 2 Columns- go to Data- Remove Duplicates:

enter image description here

Lee
  • 3,021