+ Reply to Thread
Results 1 to 3 of 3

Need Macro Coding for the finding the match case with multiple conditions and write match

  1. #1
    Registered User
    Join Date
    01-25-2015
    Location
    Delhi, India
    MS-Off Ver
    MS Office 2007
    Posts
    1

    Post Need Macro Coding for the finding the match case with multiple conditions and write match

    Dear All,

    I need a macro code for matching cases in a file and write reference code of the respective match case in different sheet.

    The file contains the patient data and the patients need to be checked and similar cases should be selected from the file.
    Match conditions
    1. Same gender
    2. Age should be +5 or -5 years
    3. For each patient with one Disability grade0 patients with other disability should be matched and found for example

    Sr No. patient ID age gender Disability Sr No. patient ID age gender Disability
    343 84994 75 male grade_0 1143 47656 70 male grade_2


    The found cases should be written in separate sheet in the same rows as:- Sr No. patient ID age gender Disability matches with Sr No. patient ID age gender Disability

    I am attaching the file for ready reference.
    Attached Files Attached Files
    Last edited by brijkishore; 01-25-2015 at 02:44 PM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,331

    Re: Need Macro Coding for the finding the match case with multiple conditions and write ma

    Hi,

    See attached.
    Attached Files Attached Files
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,331

    Re: Need Macro Coding for the finding the match case with multiple conditions and write ma

    Thanks for the rep and glad to have helped

+ 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. Replies: 2
    Last Post: 12-18-2014, 09:52 AM
  2. [SOLVED] finding partial text ,In the case of more than one match
    By fartdog01 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-20-2014, 09:20 AM
  3. [SOLVED] Macro to match decimals, write only decimal match
    By ricklou in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-27-2013, 03:04 PM
  4. How to write Macro or formula for finding 2criteria match values with comma in all cells
    By amolryeolekar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2013, 02:24 AM
  5. Replies: 13
    Last Post: 12-13-2012, 11:44 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