+ Reply to Thread
Results 1 to 8 of 8

Comparing two tables to identify matches to be highlighted

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    Sacramento
    MS-Off Ver
    Excel 2007
    Posts
    13

    Comparing two tables to identify matches to be highlighted

    I have two tables. Table A has 13 columns and 641 rows. Table B is in a different tab within my excel file but is only one column with 216 rows. Starting with Table A I need it to look up for the value in Table B. If the the value is matched, meaning they appear in both tables, I want the cell highlighted in Table A.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Comparing two tables to identify matches to be highlighted

    insert /name define (or name manager) select table b and call it say "mytable"
    in table A select first cell and conditional format as formula option assuming its say cell c1
    put
    =countif(mytable,c1) pick a colour/format
    copy the format to rest of table a
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    05-20-2013
    Location
    Sacramento
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Comparing two tables to identify matches to be highlighted

    Thank you very much it worked.

  4. #4
    Registered User
    Join Date
    06-12-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Comparing two tables to identify matches to be highlighted

    Hello,
    I'm new here and was looking for a solution to a problem that I'm having .... it's very similar to this so maybe just a bit of tweaking and it'll be good to go?

    AldenE said: "I have two tables. Table A has 13 columns and 641 rows. Table B is in a different tab within my excel file but is only one column with 216 rows. Starting with Table A I need it to look up for the value in Table B. If the the value is matched, meaning they appear in both tables, I want the cell highlighted in Table A. "

    Here's my dilemma: I have 1 tab with 4 columns and about 104 rows; I need to compare the 4 values in each row and see if there are ANY duplicates among the 4; if so I need to make them a different color or highlight them or something. Any ideas?

    Thanks a million!

  5. #5
    Registered User
    Join Date
    06-03-2013
    Location
    Jakarta, Id
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Comparing two tables to identify matches to be highlighted

    hi ! kimberly2013 try Home>conditional formatting>duplicate values

    sorry if my post oot
    - jekidi

  6. #6
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Comparing two tables to identify matches to be highlighted

    Welcome to the Forum.

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

  7. #7
    Registered User
    Join Date
    06-12-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Comparing two tables to identify matches to be highlighted

    Hi Jekidi,
    Thanks for the response - I tried that but I need to compare rows not columns and, unless I don't how, I wasn't able to do so.

    I was notified that I broke a rule in the forum by posting my question in someone else's question so I'll be creating a new question for my issue. Thanks!

  8. #8
    Registered User
    Join Date
    06-12-2013
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Comparing two tables to identify matches to be highlighted

    Sorry, I didn't realize I was breaking a rule.... I just saw this question and got pretty excited that maybe there was an answer and just replied! I admit that I did not read the rules........ I will post a new question for my issue.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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