+ Reply to Thread
Results 1 to 2 of 2

How to extract DOB values from data and then compare them ?

  1. #1
    Registered User
    Join Date
    04-20-2018
    Location
    mumbai
    MS-Off Ver
    2007
    Posts
    6

    How to extract DOB values from data and then compare them ?

    Hi I'm sharing screen shot of how an ideal output should look

    command should extract DOB values from comments data and compare extracted data for matches giving results as true or false

    DOB.JPG


    Thanks to anybody who can help me out with this
    Last edited by Ashlaad; 05-11-2018 at 11:34 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: How to extract DOB values from data and then compare them ?

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.


    To add a file to a post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare two excel files and only extract data from one file
    By Tturner in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2018, 08:06 PM
  2. [SOLVED] Compare 2 columns and Extract Data
    By mnunnley in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-08-2016, 01:53 AM
  3. [SOLVED] Compare two columns, and extract not matching data in third
    By patko15 in forum Excel General
    Replies: 2
    Last Post: 06-08-2016, 06:11 AM
  4. compare two excel sheets and extract common data
    By ravindraynk in forum Excel General
    Replies: 3
    Last Post: 07-25-2014, 10:18 AM
  5. Replies: 8
    Last Post: 09-12-2013, 09:17 AM
  6. compare and extract missing data from 2 sheets
    By BIGIFA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2011, 11:40 AM
  7. compare lists, extract new values
    By trav in forum Excel General
    Replies: 1
    Last Post: 05-16-2006, 11: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