🕒 Say goodbye to late nights and spreadsheet struggles! 🚀 Your ticket to freedom has arrived with Excel University Speed Challenge 👉 excel-university.com/challenge ⏱️ Unlock hidden Excel tricks and hacks, and become a time-saving Excel pro. ⚡️ Don't miss out, join now! 👉 excel-university.com/challenge
Subscribe here 👉 [ Ссылка ] and turn on all notifications 🔔 for MS Excel formula hacks that will make you more productive!
This video shows how to use Excel's Power Query to compare two lists. Specifically, it demonstrates:
- comparing two single-column lists
- show which values appear in both lists
- show which values appear in only one list
- matching on multiple columns
- matching on multiple columns and computing the difference between the amount values from both tables
Chapters in this video:
00:00 - Introduction
00:17 - Single Column
02:26 - Multiple Column Tables
04:05 - Compare Amounts
![](https://s2.save4k.ru/pic/7Uxx0QXfYEw/maxresdefault.jpg)