Forum Discussion

Kwaker's avatar
Kwaker
Copper Contributor
Jul 01, 2020

Compare data from 2 tables and mark it.

Good day, I'm requiring your help: I have 2 tables with 2 columns and in for every cell in both columns the data is bound together -> can you help me to make comparisons of 2 tables which contains the same data for some students and to have such output as I have it on a picture? thank you so much

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Kwaker 

    You may Power Query each table, append one to another, remove duplicates and return result to the Excel sheet.