Results 1 to 9 of 9

match columns and rows from one sheet to another sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    365

    match columns and rows from one sheet to another sheet

    I have 2 sheets "Main" and "Received"
    Both the Sheets has contains details of family as per the heading
    Family id will be unique for one particular family.

    I want to compare the details of family (Column wise and row wise in respective) in sheet "Main" with sheet "Received"
    If particular family details are matching in both the sheets, then in Sheet "Main" in Column "J" (Status) I wants result as all the details area matched.

    For Example
    Family code "053221" in main sheet is Matching with Received sheet. All details area matching Like family id, Members name, age, DOB etc. Hence in status column Marked as "ALL DETAILS MATCHED"

    Family code "023372" in main sheet is not Matching with Received sheet. The Difference is in name of the second family member. Hence in status column Marked as "NOT MATCHED"

    Family code "019340" in main sheet is not Matching with Received sheet. The Difference is in total number of family member. Hence in status column Marked as "NOT MATCHED"

    Matching Criteria to Mark status
    a) first check family id

    b) based on family id Check total Number of Family members
    if b is matching in both the sheets then move to next criteria, if not matching then mark status as details are not matched.

    c) based on family id Check total Name of all Family members
    if c) is matching both in both sheets then move to next criteria, if not matching then mark status as details are not matched.

    d) based on family id Check date of birthe of the Particular family member in both the sheets.
    if d) is matching both in both sheets then move to next criteria, if not matching then mark status as details are not matched.

    in same way match all other criteria like age, gender, relation and income group.

    If all the details are Matched then give status as " ALL Details are Matched"

    please find attached sheet for example. Differences are marked in red colour
    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. Replies: 0
    Last Post: 01-13-2013, 07:06 PM
  2. Replies: 0
    Last Post: 11-08-2012, 05:05 PM
  3. Match two Columns of two Sheets and Copy Matched Rows to a Third Sheet
    By Par in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 10:16 AM
  4. Replies: 0
    Last Post: 10-25-2012, 03:38 PM
  5. Two Columns must match in sheet one and sheet two then lookup column C
    By Pavan Kumar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-18-2011, 11:32 AM
  6. Populate summary sheet (insert & index rows from info in columns on another sheet)
    By DerbysGal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-03-2011, 01:54 PM
  7. Match column from sheet 2 to sheet 1 and copy rows if match exists.
    By GravityInvert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2008, 01:42 PM

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