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 combined at the same time.
i.e. records in excel sheet should have unique entries for FirstName,MiddleName,Surname combination
Awaiting pointers, whereby above scenario is addressed.
i.e. records in excel sheet should have unique entries for FirstName,MiddleName,Surname combination
Awaiting pointers, whereby above scenario is addressed.