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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top