+ Reply to Thread
Results 1 to 3 of 3

Look up between 2 table for match data with no order

  1. #1
    Registered User
    Join Date
    08-14-2019
    Location
    Netherlands
    MS-Off Ver
    2019
    Posts
    36

    Question Look up between 2 table for match data with no order

    Hi guys,

    I've got 2 files with 1 milion rows per table, i need to match 2 columns to check table1 contain all data from table2.
    Problem is per 1 code is avg 10-20 rows in random order and i just dont know how to compare it, I included file with sample 1 code to show how its look like. In whole file its should be like 100% coverage but if something is missing or doesnt match, can we also show what is it?
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Look up between 2 table for match data with no order

    Formula for 1 milion is really slow.
    I would use Power Query
    Open Power Query/Get and Transform. Click on New Query.
    Open blank query in the editor, launch Advanced Editor and paste in the following code.


    Please Login or Register  to view this content.
    to show miss match from Table4

    or from Table5
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-14-2019
    Location
    Netherlands
    MS-Off Ver
    2019
    Posts
    36

    Re: Look up between 2 table for match data with no order

    This is excatly what i needed , thanks a lot !!!

+ 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] Index-match or Pivot table 1 name shows everything they did for the day in time order
    By justinwb in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-07-2017, 03:58 AM
  2. Compare to strings for a match (string data may not be in same order)
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2016, 02:47 PM
  3. Replies: 5
    Last Post: 01-28-2016, 01:43 PM
  4. [SOLVED] to spread data in a column in order to match it wit other colums
    By utsilasi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-13-2014, 10:28 AM
  5. Sort data to match a predefined list order
    By Neil0782 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-12-2012, 08:53 AM
  6. get data from a table in the right order
    By keis386 in forum Excel General
    Replies: 0
    Last Post: 04-15-2011, 11:29 AM
  7. Data Table Order
    By HelpRequired in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-14-2007, 08:12 AM

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