+ Reply to Thread
Results 1 to 7 of 7

Match data in two tabs

  1. #1
    Registered User
    Join Date
    05-10-2010
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2003
    Posts
    12

    Match data in two tabs

    Hi All,

    I have to sort a massive RSVP list. I have two tabs, one has the names of the people that are attending, and their guest, the other has the names of all the people invited. Is there a way to compare both sheets and highlight, or remove, the names that DO NOT show up twice. Any help would be very appreciate...it's a very large list.


    Thanks!
    Last edited by Excelinfant_2010; 04-27-2011 at 03:02 PM.

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Match data in two tabs

    Excelinfant_2010,

    For something like that I would recommend:
    Copy the list of people invited
    Paste it in the same sheet as the list of people attending
    Select/Highlight the whole range
    With it selected, go to Conditional Formatting -> Duplicate values -> change the drop down to Unique values

    Then only the unique values will be highlighted

    Hope this helps,
    ~tigeravatar

  3. #3
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Match data in two tabs

    Sure - post a copy of your workbook. I'd identify using countif or sumproduct.
    If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
    Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...

    Thomas Lafferty
    Analyst/Programmer

  4. #4
    Registered User
    Join Date
    05-10-2010
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Match data in two tabs

    Thanks tigeravatar, I will give that a shout.

    Thomas, thanks so much for the offer, but as it's a compnay list of personal names, I can't post it. Thanks again though!

  5. #5
    Registered User
    Join Date
    05-10-2010
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Match data in two tabs

    Is this tip for 2007? I'm currently on 2003.

  6. #6
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: Match data in two tabs

    let's say your master and RSVP lists have names in the A column.
    To the right of your Masterlist, add a column labeled Count. Enter this formula:
    Please Login or Register  to view this content.
    Fill down, then sort or filter.

  7. #7
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Match data in two tabs

    Quote Originally Posted by Excelinfant_2010 View Post
    Is this tip for 2007? I'm currently on 2003.
    Sorry, it is indeed for 2007, I should have noticed you were on 2003. To use conditional formatting to get the same effect, you would put in a conditional format formula:

    =COUNTIF($A:B,A1)>1

    Assuming the names were in columns A and B, starting in cell A1.

    tlafferty's suggestion should also work.

    ~tigeravatar

+ 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