Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Everything about Charts in Excel
  • Understanding Anova in Excel
  • How To Insert and Customize Sparklines in Excel
  • How to Create Area Chart in Excel
  • How to Create Column Chart in Excel

References

  • How to get relative row numbers in a range in Excel
  • How to use Excel ROWS Function
  • How to get first row number in range in Excel
  • How to use Excel OFFSET function
  • Two-way lookup with VLOOKUP in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation require unique number
  • Excel Data validation date in next 30 days
  • Excel Data validation date in specific year
  • Excel Data validation only dates between

SMALL function: Description, Usage, Syntax, Examples and Explanation

by

What is SMALL function in Excel?

SMALL function is one of Statistical functions in Microsoft Excel that returns the k-th smallest value in a data set. Use this function to return values with a particular relative standing in a data set.

Syntax of SMALL function

SMALL(array, k)

The SMALL function syntax has the following arguments:

  • Array:  An array or range of numerical data for which you want to determine the k-th smallest value.
  • K: The position (from the smallest) in the array or range of data to return.
Worked Example:   Sum bottom n values in Excel

Explanation of SMALL function

  • If array is empty, SMALL returns the #NUM! error value.
  • If k ≤ 0 or if k exceeds the number of data points, SMALL returns the #NUM! error value.
  • If n is the number of data points in array, SMALL(array,1) equals the smallest value, and SMALL(array,n) equals the largest value.
Worked Example:   nth smallest value in Excel

Example of SMALL function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

Worked Example:   Extract multiple matches into separate columns in Excel

You can adjust the column widths to see all the data, if need be.

Data 1 Data 2
3 1
4 4
5 8
2 3
3 7
4 12
6 54
4 8
7 23
Formula Description (Result) Result
=SMALL(A2:A10,4) 4th smallest number in first column (4) 4
=SMALL(B2:B10,2) 2nd smallest number in the second column (3) 3

Post navigation

Previous Post:

CUBEVALUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

DVARP function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Return blank if in Excel
  • How to use Excel OR Function
  • Extract multiple matches into separate rows in Excel
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Logical Functions, References and Examples

Date Time

  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to get number of days, weeks, months or years between two dates in Excel
  • Add decimal hours to time in Excel
  • How to calculate next anniversary date or birthday in Excel
  • Add workdays to date custom weekends in Excel

Grouping

  • How to randomly assign data to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Group arbitrary text values in Excel
  • Running count group by n size in Excel
  • Map inputs to arbitrary values in Excel

General

  • Customize Ribbon In Excel
  • How to calculate percent of goal in Excel
  • Split Cell Content Using Text to Columns in Excel
  • How to fill cell ranges with random number from fixed set of options in Excel
  • Using Existing Templates in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning