Results 1 to 10 of 10

Data matching and validation

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-26-2014
    Location
    Kentucky
    MS-Off Ver
    Excel 2013
    Posts
    128

    Data matching and validation

    I have data in two different columns in sheet 1. The data should contain the same number strings as each other. I have been unsuccessful creating a code that could verify that the numbers in each column are the same. The order by rows is not important, only that one column doesn't have extra or less rows of these number strings as the other. I have attached a workbook that will further explain this. Help would be greatly appreciated. Thank you.
    Data validation question.xlsx
    Last edited by RaydenUK; 02-26-2015 at 08:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Prevent matching entries on same row from appearing in the Data Validation dynamic range.
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 12-22-2013, 01:32 PM
  2. Help! I need to add together cells with a matching data validation
    By grahamkendall82 in forum Excel General
    Replies: 6
    Last Post: 02-15-2012, 02:48 AM
  3. Calculating Time matching info in Data Validation Column and Date
    By dbroderick in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2010, 04:22 PM
  4. Data matching with data validation
    By nikesone in forum Excel General
    Replies: 2
    Last Post: 10-30-2008, 07:52 PM
  5. Data Validation via Matching?
    By Centrum in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-13-2007, 09:08 AM

Tags for this Thread

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