Yes. It always must match what is in Column 1 and also what is in Column 2. You can fake it out and put the same thing in both columns so effectively it is matching only a single column, but it still must match 1 and 2 simultaneously to be considered a duplicate.
|