Run your modified query in your SQL browser to view the results. If a duplicate key is found, the query will update the existing column instead of erroring out.

I’m a duplicate!”,”Original”) Copy the formula to D3:D9. At this point, finding multi-column duplicates is as easy as sorting by column D (although this example doesn’t require any sorting).