Quick list comparisons with Pivot Tables
Опубликовано: 11 Октябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting
233
1
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.
