Excel Magic Trick 1133

Aging Accounts Receivable Reports: PivotTable & Unique Identifier

DESCRIPTION

See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable where or not there are duplicate records:
(01:49) Days Late Helper Column Formula: TODAY function and relative cell reference
(02:46) Report Category Helper Column Formula using VLOOKUP
(03:45) Unique identifier Helper Column Formula using COUNTIF, expandable range and Join Symbol
(05:55) PivotTable based on Invoice Column
(08:48) PivotTable based on Unique identifier column

WORKBOOKS