Search results

Thanks for the response Luke as well as Muneer. Shrivallabha your are right, that I would have to add one more field to get the unique key.

I want to prevent duplicate entries in three columns combined using data validation, i.e. for example column A has first name and Column B has middle name, Column C has last name. The first name can be duplicate, middle name can be duplicate, last name can be duplicate, but not all three...