Results 1 to 3 of 3
  1. #1
    Delta223 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    38

    Duplicate value Alerts?

    Hi all,



    Is there any way for excel to alert me to a duplicate value entered into the same column? Preferably ignoring capitalization (as my values do have alpha characters)

    I have a spreadsheet that lists all my inventory, and it would be a pretty big issue if I gave the same inventory # to 2 different products!

    Thanks
    Last edited by Delta223; 01-12-2012 at 11:09 AM.

  2. #2
    gregu710 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Location
    Frederick, CO (near Longmont and Boulder)
    Posts
    40
    Delta, have you tried Conditional Formatting the column to highlight Duplicates? I've got a rather large spreadsheet where I have to ensure that I don't enter a duplicate value (also alphanumeric, but always capitalized), of some 400 entries, and do it with Conditional Formatting. I've also got a cell that checks MODE on that Column, which returns any values that appear more than one time.

  3. #3
    Delta223 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    38
    Just tried it and it works beautifully, thanks for the tip!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Possible Duplicate Help
    By dave559 in forum Programming
    Replies: 0
    Last Post: 02-22-2011, 08:01 PM
  2. Duplicate Register
    By maluna in forum Access
    Replies: 1
    Last Post: 09-28-2010, 12:45 AM
  3. Duplicate a row
    By thestappa in forum Programming
    Replies: 3
    Last Post: 06-01-2010, 02:37 PM
  4. Duplicate first row
    By kruai in forum Access
    Replies: 1
    Last Post: 06-22-2009, 02:06 PM
  5. Which duplicate?
    By grgerhard in forum Import/Export Data
    Replies: 1
    Last Post: 05-27-2006, 06:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums