YTLE#104: Find 1st Positive# in Excel List

3,872 views · Published 30 August 2008 · 6:24 · Indexed 28 September 2026

Channel: excelisfun · 2008 · Science & Technology

Watch on YouTube

Download Excel Files:
Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/YTLE101-111.xls
Finished File https://people.highline.edu/mgirvin/YouTubeExcelIsFun/YTLE101-111Finished.xls
Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm

In Excel, see how to use a TRUE/FALSE COUNTIF formula and an Array Formula with the MATCH function to find the first positive number in a list.

See COUNTIF, AND and MATCH functions in formulas.

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

• 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

• 2:33 Excel Magic Trick #204: Adding w Case Sensitive Criteria

  excelisfun

  4,240 views · 9 January 2009