Excel Forum

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

Got a Question? Ask it Here in the Forum.