+ Reply to Thread
Results 1 to 2 of 2

Compare data between two tables

  1. #1
    Registered User
    Join Date
    11-09-2023
    Location
    US
    MS-Off Ver
    2019
    Posts
    1

    Compare data between two tables

    Hi, I need a formula to compare 2 tables with header "model"
    ability to include or exclude data when compare.
    I have tried this but unsuccessfully. if anyone can help, with other tools that will be great too. thanks in advance

    =COUNTIF(Table2[Model],[Model])=1

    Data 1
    Model QTY Location
    4548549 EA 90011
    544873 EA 90650
    547907 EA 91331
    547297 EA 94565
    549177 EA 90044
    549303 EA 92336
    724543 EA 92335
    73177 EA 90805
    745424 EA 90250
    75454254 EA 90201
    77182 EA 90280
    791754 EA 91342
    7954547 EA 92683
    70297 EA 90011
    711543 EA 90650
    730549 EA 91331
    745428 EA 94565
    814854 EA 90044
    825404 EA 92336
    84834 EA 92335
    854108 EA 90805






    Data 2
    Model
    54863
    56906
    547907
    745424
    69175
    85540
    62453

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,908

    Re: Compare data between two tables

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Compare two tables and transfer data to different tables based on conditions.
    By kv.singh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2020, 09:38 AM
  2. compare tables data
    By ghassenfocus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2013, 04:27 PM
  3. Compare two data tables
    By xpiamchris in forum Excel General
    Replies: 3
    Last Post: 03-24-2011, 11:32 PM
  4. Replies: 0
    Last Post: 04-17-2010, 07:33 AM
  5. Excel 2007 : How to compare data in two tables?
    By learner6 in forum Excel General
    Replies: 4
    Last Post: 04-05-2009, 12:59 AM
  6. How to compare two tables of data
    By grdipajek in forum Access Tables & Databases
    Replies: 1
    Last Post: 02-13-2009, 06:30 AM
  7. To compare to tables of data
    By kucinskij in forum Excel General
    Replies: 1
    Last Post: 10-08-2007, 01:19 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