Рет қаралды 4,643
You have two tables and you're trying to reconcile the list of items between the two. You're concerned not with matches but with the differences between the two tables. You need to highlight or show entries that should have a common column entries in both columns and show what records have the missing information. What are the entries that don't have a match between both tables? In SQL that would be called anti-join, but you don't have to know SQL to do this. Just open up Power Query and use the merge commands. It's a bit involved but not that complicated. See how...
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~