Preventing duplicate entries

[ghamic]

I want to create a training schedule in Excel. There would be columns such as class, date, location, instructor, etc. I want to make sure that, for any given date, the instructor and location are not double-booked. Instructor names will repeat in the instructor column, but should not repeat on the same date. Same for location.

 

[NateO]

Hello, welcome to our forums.

I used Data Validation in A1 to make sure columns A and B have unique Records, with the following:

=SUMPRODUCT(($A$1:$A$1000=$A1)*($B$1:$B$1000=$B1))=1

I selected A1, I clicked Data->Validation...->Custom and entered the function.

Then I copied A1 and seleted A1:B1000 and did a Paste Special->Validation.

You could add other columns in a similar manner, if need be. :wink:

 

[Atoosa]

Hello, welcome to our forums.

I used Data Validation in A1 to make sure columns A and B have unique Records, with the following:

=SUMPRODUCT(($A$1:$A$1000=$A1)*($B$1:$B$1000=$B1))=1

I selected A1, I clicked Data->Validation...->Custom and entered the function.

Then I copied A1 and seleted A1:B1000 and did a Paste Special->Validation.

You could add other columns in a similar manner, if need be. :wink:

Is there a way to ensure that numbers cannot be duplicated in a column?

 

[al_b_cnu]

Is there a way to ensure that numbers cannot be duplicated in a column?

answered in your other post!