Main Profile

At A Glance

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
Length: 11:45

Contact

Questions about Excel Magic Trick 569: Extract Past Due Loans - Dynamic Formula

Want more info about Excel Magic Trick 569: Extract Past Due Loans - Dynamic Formula? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question