WeCode
Academy
Tutorials
Web Development
Bootstrap
CSS
HTML
JavaScript
jQuery
Node.js
PHP
React
TypeScript
Programming
C
C#
C++
Go
Java
Python
Rust
Data and Databases
AI Foundations
Cybersecurity Fundamentals
Data Structures and Algorithms
Data Visualisation
Databases
Excel
Machine Learning
NumPy
Pandas
SQL
Statistics
Tools
Bash
Git
Projects
Project: A Tiny Shell in C
Project: Bank Account System
Project: Library Management System
Project: Portfolio Page
Project: Quiz App in React
Project: Sales Data Analysis
Project: Server Log Analyser
Project: To-Do REST API
Project: URL Shortener
Project: Word Counter in Four Languages
All tutorials ❯
Paths
References
Practice
Try it editor
Quizzes
How To recipes
Tools
Glossary
My Learning
🌙
Dark mode
Home
›
References
›
Excel Function Reference
❮ LARGE
RANK ❯
SMALL
The k-th smallest number.
Group: Statistics
Syntax
SMALL(range, k)
Example
Example
excel
A1: 12 A2: 7 A3: 25 A4: 7 A5: 18 C1: =SMALL(A1:A5,2)
Run ❯
Reset
Open in editor »
← All of Excel Function Reference