+ Reply to Thread
Results 1 to 3 of 3

Power Query to Compare Tables

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Power Query to Compare Tables

    Hi,

    I want to compare Column A in Scheme_A and Scheme B
    Result: Display common values both schemes in tab named "Compare" along with respective % of total holding for common values returned
    Have shown one example in compare tab
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Power Query to Compare Tables

    Like this?
    Attached Files Attached Files
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Re: Power Query to Compare Tables

    Revised and attached. It should display only Rows 13,23,24,26,30,33,34 because column A appears in both Scheme A and Scheme B
    Attached Files Attached Files

+ 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. Combining three tables using power query
    By sunboy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-08-2022, 05:29 AM
  2. [SOLVED] Power Query: Appending Tables
    By andrewc in forum Excel General
    Replies: 4
    Last Post: 08-26-2021, 09:48 AM
  3. [SOLVED] Combine tables in Power Query
    By Ebl in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 08-02-2021, 08:11 AM
  4. Help Using Power Query to compare
    By lgsikaffy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2020, 04:37 AM
  5. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  6. Power Query tables in VBA
    By orhanceliloglu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2018, 08:25 AM
  7. Power Query - how to append tables
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2015, 04:55 AM

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