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.