Results 1 to 53 of 53

Name check / data validation formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-04-2014
    Location
    Nevada, USA
    MS-Off Ver
    2019
    Posts
    345

    Name check / data validation formula

    Hi Folks,
    I have a new question about validating or identifying incorrect data.
    I have uploaded an example spreadsheet.
    I have about 100,000 lines of such data to work with.
    So, I would like to know if anyone can provide me a formula that I can copy and past down to solve my problem.

    The issue is this:
    The last name of the Actor in cell F4 must match with the last name of data in cell G3.
    If the names match, in cell H3, it needs to return "OK" else "NO"

    The formula would then have to skip F5:G6 and search for a data match in cells F8 and G7
    in the example provided, there is a typo in the last name in cell G7. So, the returned answer in H7 will be "NO"

    I am looking for a formula, that I can copy and paste down for about a 100,100 such entries - to search for typos and name discrepancies.
    All the entries are separated by the two blank cell spaces.

    Any assistance would be appreciated.
    Thank you
    Doofus
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to check if custom data validation formula is volatile?
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-08-2021, 07:04 AM
  2. Replies: 7
    Last Post: 02-12-2016, 01:54 PM
  3. Data validation check
    By amt7565 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-09-2014, 10:12 AM
  4. Data Check and Validation
    By Nairobi Nice in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 08:29 AM
  5. How to use Data Validation to check?
    By gilbert in forum Excel General
    Replies: 3
    Last Post: 06-09-2011, 09:11 PM
  6. Data Validation Check
    By james598 in forum Excel General
    Replies: 0
    Last Post: 07-22-2009, 11:59 AM
  7. Validation Formula To Cross Check Cells
    By swordswinger710 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2008, 10:22 AM

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