Use Excel Power Query to Reconcile Tables
HTML-код
- Опубликовано: 15 окт 2024
- 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...
~-~~-~~~-~~-~
I have successfully done BANK RECONCILIATION STATEMENT using Left and right anti join .RECONCILIATION of any kind
is important for accounts/fianance guys.PQ is Very helpful in this matter.thanks to yu i have learned all this from yu.
Pl start a series on POWER PIOVT(basic to advanced).thank yu
Hi chandra mohan, thanks for the comment!
Hi Doug. Nice work-around to create a full anti-join. Thanks for sharing your technique. Thumbs up!!
Thanks Wayne, appreciate the comment !!
Hi have been watching your videos about reconciliation using power query, you have really helped me. Now how can you match the positive(debt) and negative(credit) amounts not references. Let's say if the ledger references(using voucher number to payments) are different from bank references in excel power query suppliers reconciliation
Good solution. Thanks Doug!
You’re welcome!
Thanks for showing us this. My experience is that my recon's are more messy. In your example, we could have just done a v lookup to have the same result. How do you manage if you do not have a common column? I have situations where the accounting software has multiple entries that add up to one entry on the bank entry side. ie. 4 $25 entries on the accounting software side, and 1 $100 entry on the bank statement. Any Power Query advice?
Thank you very much for a very useful informative video
So nice of you!
Thank you very useful🙌
You're welcome 😊
This is slick man, thanks so much
You’re welcome!
Very useful, some background crackling noises could be mic sensitivity very high.
Noted!