0 Replies Latest reply: Dec 8, 2012 4:44 AM by melaniehuggins RSS

    duplicate records

      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