|
Featured Tutorial
Featured Macro
Excel Magic Trick 569: Extract Past Due Loans - Dynamic Formula
See how to create an array formula that will extract loan records that are past due. The formula is dynamic so that as loans come due or as loans are added to the database, the extract area updates. See the functions: COUNTIFS, SUMPRODUCT, IF, ROWS, INDEX, SMALL, ROW