+ Reply to Thread
Results 1 to 3 of 3

Data Validation - Not Allow Duplicate Values

  1. #1
    Forum Contributor
    Join Date
    02-11-2009
    Location
    Montclair, NJ
    MS-Off Ver
    Excel 365
    Posts
    224

    Data Validation - Not Allow Duplicate Values

    Hey,

    I have a project I've been working on and I need help with something

    I need to use Data Validation to not allow any Duplicate Values

    In the attachment there is a spreadsheet to show what I'm looking for

    Summary:
    Inputted Values in F7 <> Values in range I7:Q9
    If F7 = any value in the range, Data Validation suggests to change the value


    If someone could help me on this I'd greatly appreciate it

    Thank you sooo much for your time and efforts,
    Bob
    Attached Files Attached Files
    Last edited by sighlent1; 01-26-2011 at 02:29 PM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Data Validation - Not Allow Duplicate Values

    Try this formula
    =NOT(COUNTIF($I$7:$Q$9,$F$7)) and set your Error Alert to "Warning" and input an appropriate message.
    Does that work for you?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    02-11-2009
    Location
    Montclair, NJ
    MS-Off Ver
    Excel 365
    Posts
    224

    Re: Data Validation - Not Allow Duplicate Values

    ChemistB!!!!.....Thank you SOOOO much......that's EXACTLY what I was looking for

    Thank you
    Bob

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1