Pinterest Pixel

SMALL Formula in Excel

Bryan
 .
SMALL Formula in Excel | MyExcelOnline SMALL Formula in Excel | MyExcelOnline

What does it do?

Get the nth smallest value from a range of values

Formula breakdown:

=SMALL(array, k)

What it means:

=SMALL(range of values, position of the smallest value)


You have a list of values and you want to get the third (or nth) smallest value, no problem! Excel’s SMALL Formula can easily get that for you!

I explain how you can do this below:

SMALL Formula in Excel | MyExcelOnline

Download excel workbookSMALL-FORMULA.xlsx

STEP 1: We need to enter the SMALL function in a blank cell:

=SMALL(

SMALL Formula in Excel

 

STEP 2: The SMALL arguments:

Table of Contents

array

What is the range of values?

Select the cells containing your values:

=SMALL(C9:C12,

SMALL Formula in Excel

k

What is the nth smallest value that you want to get?

We want to get the third smallest value so we will place in 3.

=SMALL(C9:C12, 3)

SMALL Formula in Excel

 

You now have your third smallest value!

SMALL Formula in Excel

 

How to Use the SMALL Formula in Excel

 

SMALL Formula in Excel | MyExcelOnline

 

If you like this Excel tip, please share it
SMALL Formula in Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  How to use ChatGPT with Microsoft Excel - The Ultimate Guide

Steps To Follow

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...