Excel Magic Trick 853: Lookup Number That Occurs Least Frequently (2 Methods)

4,675 views · Published 5 January 2012 · 6:37 · Indexed 28 October 2026

Channel: excelisfun · 2012 · Education

Watch on YouTube

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT850-853.xlsm

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to Lookup Number That Occurs Least Frequently:
1. See formula that uses a helper column and uses the functions IF, ISNUMBER, COUNTIF, INDEX, MATCH and MIN.
2. See single cell formula that uses the functions IF, ISNUMBER, COUNTIF, INDEX, MATCH and MIN. Array Formula

More from this channel

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

  excelisfun

  3,560 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,596 views · 30 May 2008

• 3:41 YouTubersLoveExcel#26.2: Formulas do not like TEXT Time

  excelisfun

  2,016 views · 6 June 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,877 views · 11 June 2008

• 9:27 YouTubersLoveExcel#31: Dates, Cash Flow & Logic

  excelisfun

  4,909 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 7:38 YouTubersLoveExcel#52: VLOOKUP & Workbook References

  excelisfun

  3,914 views · 7 July 2008

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

  excelisfun

  4,807 views · 18 July 2008