prevent duplicates

  1. sdkorin

    Preventing Duplicates Across many ranges

    Greeting all! I am working with a spreadsheet that tracks staffing across multiple areas. What I need is to be able to prevent duplicates in specific areas of the spreadsheet. It has to be these specific areas because some areas are supposed to allow duplicates. Here are my ranges...
  2. K

    Prevent users from entering Duplicate Data

    I created a VBA code that will prevent users from selecting duplicate data from a drop down list in column C of my excel spreadsheet, however I want users to be able to select "Other" in multiple fields without receiving an error. Here is the code that I have written but need to show how to...
  3. K

    How To Prevent Duplicate URL Entries in the Cell in a Column?

    Dear Experts, I tried to solve above problem using Data Validation formula but it does not help as per my wish. Because data validation does not work if somebody copy paste the duplicate values,it works when somebody types duplicate values in next column. So if I want to enter lot of urls to a...
  4. A

    Prevent Duplicate Enteries

    Hi Excel Leaders, Need help in achieving following: I got 8 columns <tbody> A B C D E F G H 1 M W 1 1 4 5 6 =concatenate(a1,b1,c1,d1,e1,f1,g1) 2 M W 1 1 4 5 6 =concatenate(a1,b1,c1,d1,e1,f1,g1) </tbody> Now I want to avoid duplicate values in Column H Please help me...
  5. F

    Prevent duplicate in userform if range cell is specific color.

    Hello. Right now on a user form, I have an If statement that when a part is listed, it checks to see if it's a duplicate. What I would like to do is if the cell color in the range is Yellow (VB colorindex is 6) then it allows for a duplicate entry, but if the cell color is not yellow, then it...

Watch MrExcel Video

This Week's Hot Topics

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