• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About

Excel SMALL Function

The Excel SMALL function is used to return a value dependent upon its ranking in a range of values. For example, the SMALL function can be used to return the 2nd or 3rd smallest number from a range.

The syntax for the SMALL function is:

=SMALL(array,k)

ArgumentPurpose
Arraythe range of cells you want to find the k-th smallest value in
KThe position in the range of numbers, from the smallest, that you want to return

The example below shows the SMALL function being used to select values from a range.

Excel SMALL function to return the second or third smallest value
FunctionResult
=SMALL(A2:A11,2)6
=SMALL(A2:A11,5)102
=SMALL(A2:A11,1)2

Primary Sidebar

Recent Posts

  • Stop PivotTable Columns Resizing
  • LIVE Currency Exchange Rate in Excel
  • N Function in Excel
  • Non-Adjacent Columns with FILTER Function
  • Moving Average in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2009 Computergaga · All Rights Reserved ·