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

3,863 views · Published 9 April 2010 · 11:45 · Indexed 28 September 2026

Channel: excelisfun · 2010 · Science & Technology

Watch on YouTube

Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT568-569.xls

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

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,557 views · 23 May 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008

• 8:18 YTLE#80: Conditional Format MATCH & INSUMBER functions

  excelisfun

  3,669 views · 4 August 2008

• 4:16 YTLE#82: Enter UPPER Case Text Only Into The Cell

  excelisfun

  2,676 views · 7 August 2008

• 3:22 YTLE#93: "Go To Special Blanks" Caveat

  excelisfun

  1,663 views · 12 August 2008

• 6:24 YTLE#104: Find 1st Positive# in Excel List

  excelisfun

  3,872 views · 30 August 2008

• 4:50 YTL Excel #123: Array Formula To Count E-mails

  excelisfun

  2,540 views · 11 September 2008

• 0:03 Family At Christmas Tree

  excelisfun

  4,723 views · 3 January 2009