Check each column individually, and put a 1 or a 0 in a cell below each column. Then test that row of values for a 1. Not pretty, but functional.
Prevent duplicates before they happen by combining a simple function with data validation. We may earn from vendors via affiliate links or sponsorships. This might affect product placement on our site ...