I'm loading into QV two spreadsheets where I want to identify duplicates. Column names are similar to
Table 1
Date
Site
Breach
Score
Table2
Date
Site
Reason
Value
I want to find all the duplicate records where all values match, so there will be some text in the breach and reason colunm that should match, same with date etc. Each table has about 200 records.
Anyone got any suggestions. Thanks