Jump to content

How to remove rows with same column values from two data tables

joy lee 2

Recommended Posts

I have two Excel sheets with rows with the same column value.

I want to remove the row with the same ID,INDEX,CODE as the left table like the attached file.

Is there a way to remove it using a join method I'd like to process about 100,000 data sets.

please let me know how to do this..

Link to comment
Share on other sites

  • Create New...