Quick list comparisons with Pivot Tables
on channel: AuditExcel Advanced Excel and Financial Model Training and Consulting
00:00 Match item in 2 lists (payments versus charges) using Pivot Tables
00:22 Label the lists (invoice versus payment)
00:45 Join the lists together to create a Pivotable database
01:10 Create the Pivot Table
01:23 Match invoice to payment
02:00 Items that reconcile and items that don't
Using a Pivot Table to reconcile invoices and payments in 2 different lists to see which reconcile completely, partially and which are missing payments.
Watch video Quick list comparisons with Pivot Tables online without registration, duration hours minute second in high quality. This video was added by user AuditExcel Advanced Excel and Financial Model Training and Consulting 30 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 233 once and liked it 1 people.