Preventing duplicate entries

ghamic

New Member
Joined
Aug 27, 2007
Messages
1
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.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
Hello, welcome to our forums. :)

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

Code:
=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

New Member
Joined
Apr 24, 2008
Messages
25
Hello, welcome to our forums. :)

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

Code:
=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?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,384
Messages
5,601,323
Members
414,442
Latest member
Oleg

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top