+ Reply to Thread
Results 1 to 9 of 9

Tables comparison along with rows comparison and mismatch rectified with color notificatio

  1. #1
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Tables comparison along with rows comparison and mismatch rectified with color notificatio

    Table 1
    Postal Code Place Name State Abbreviation County
    73851 May Oklahoma OK Harper
    76857 May Texas TX Brown
    83253 May Idaho ID Lemhi


    Table 2
    Postal Code Place Name State Abbreviation County
    73851 Me Oklahoma OK Harper
    76857 May Texes TX Brown
    8253 May Idaho ID Lemhi

    1) Compare Table 1 with Table 2
    2) wherever the value in table 2 is not matching with Table 1 it should be coloured out and rectified to correct one as given in table 1.
    3) Ensure All the parameter in Row1 of table 2 should be compared with all parameter in Row 1 of Table 1 so that required value is updated.

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Tables comparison along with rows comparison and mismatch rectified with color notific

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Tables comparison along with rows comparison and mismatch rectified with color notific

    Please find attached my file. Table 1 is my main, table 2 is my table with incorrect entries, In table 3 I want correct entries to be filled. I want to tally all columns of my table to be verified to retrieve the correct information.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,560

    Re: Tables comparison along with rows comparison and mismatch rectified with color notific

    Just copy table1 to table3.....

  5. #5
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Tables comparison along with rows comparison and mismatch rectified with color notific

    Situation is

    1) Table 1 is downloaded from internet

    2) Table 2 is a manual entry wherein chances are infinity to do typing mistake.

    3) My intent is to correct this typing error. And in order to do so my logic is to compare each row/cell of table 2 with table 1 and wherever there is typo against the value it should be rectified.

    4) We could use Code as primary key, but there could be typing mistake in code entry also. So not sure how to handle this situation and where I need code to rectify the typing mistake at any row.

  6. #6
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Tables comparison along with rows comparison and mismatch rectified with color notific

    Your explanation doesn't make sense. If table1 is a correct example of what you are looking for, then use table1.

  7. #7
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Tables comparison along with rows comparison and mismatch rectified with color notific

    I am collating a information where I am copying information from the internet which is a manual entry. In Table 2,I have just shown some of the columns from my main data.

    I just want my table 2 where I am making typo errors should be rectified based on Table 1(as reference). Does this convey what my problem area is or you think I am not able to frame my query correctly?

  8. #8
    Forum Contributor
    Join Date
    10-01-2015
    Location
    Delhi
    MS-Off Ver
    2013
    Posts
    105

    Re: Tables comparison along with rows comparison and mismatch rectified with color notific

    Can anyone help with the solution please?

  9. #9
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Tables comparison along with rows comparison and mismatch rectified with color notific

    In your example with the exception of a few typographical errors, table 2 seems to be identical to table 1. It has the same number of items and they are in the exact same spot, meaning rows and columns. Your typographical errors are in different columns, meaning in one the code is incorrect but all other items are correct. In others the place name is correct but other items are incorrect. How does one help you with this? If you said all the codes are correct but other items are misspelled I would say use a vlookup or index match formula. If you said all the other items were correct but the codes are wrong I would say we could probably use all the other items to look up the codes.


    Does this convey what my problem area is or you think I am not able to frame my query correctly?
    So yes I/we or maybe it's just me, are confused as to how to help you.

    You don't seem to understand my/our position is that we don't understand why you can't just use table 1, again read my explanation above. You need to understand the difficulty in helping you.

    The bottom line is if you have a table that is correct that you want us to somehow use code on to compare it to another table then you don't need the table with typos use the other table.

+ 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. How to use Excel data to generate new comparison tables
    By prk91 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2015, 12:34 PM
  2. Complex Comparison formula between 2 separate tables
    By AJChappy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2015, 01:22 PM
  3. Type Mismatch, InStr() By Text Comparison
    By BlazzedTroll in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2013, 12:11 PM
  4. Excel 2007 : Comparison of Two Tables
    By selva991 in forum Excel General
    Replies: 3
    Last Post: 10-21-2011, 05:19 AM
  5. comparison between two tables
    By legolas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-12-2011, 05:05 AM
  6. Excel macro - color comparison 2 doc
    By Zd3n3k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2011, 08:09 AM
  7. [SOLVED] Comparison result changes font color
    By GScott in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2006, 01:47 PM

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