Excel, Decelerated: Cross-check an invoice batch
Techniques: UNIQUE, SORT, DROP, MAP, LAMBDA, ROW, SUMIF, SUMPRODUCT, COUNTA, PivotTable. Need to check your stats before uploading an invoice batch to Xero? Watch the video and download the Excel template to learn how.