Look Who it Was Random video

Excel - Master Excel Functions: Find Second Smallest Value & Sort Data Tutorial - Episode 1037

483 views · Published 16 June 2009 · 1:57 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel Functions: Find Second Smallest Value & Sort Data.

Welcome back to the MrExcel netcast! In this episode, we're going to tackle a common problem faced by many Excel users - finding the second smallest value in a data set. I recently encountered this question during my seminar at the IMA national meeting in Denver, and I'm excited to share the solution with you.

So, how do we find the second smallest value in a data set? Of course, we all know how to find the smallest value using the MIN function. But what about the second smallest? This is where the SMALL function comes in. By simply specifying the range and the position of the value we want (in this case, the second smallest), we can easily retrieve the desired result.

But that's not all - the SMALL function has even more tricks up its sleeve. Not only can it help us find the second smallest value, but it can also be used to sort a data set without actually sorting the original data. This is a great way to analyze and organize your data without altering the original set. And if you like SMALL, you'll also love LARGE - a function that helps you find the second largest, third largest, and so on.

I hope you found this tip helpful and will be able to use it in your own Excel projects. If you want to learn more about Excel and its powerful functions, be sure to check out my other netcasts on this channel. And if you have any questions or suggestions for future episodes, leave them in the comments below. Thanks for watching and see you next time on the MrExcel netcast!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


If you need to find the smallest value in a range, you would use MIN. Episode 1037 will show you how to find the second smallest value, third largest value and so on. Also in this episode, sort with a formula.

Table of Contents:
(00:00) Finding the second smallest value in a data set
(00:33) Using the SMALL function to find the second smallest value
(00:55) Sorting data without changing the original data set
(01:06) Using the LARGE function to find the second largest value
(01:34) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Analyzing data
Finding second largest value in a data set
Finding second smallest value in a data set
Finding smallest value in a data set
IMA Power Excel seminar
LARGE function in Excel
MrExcel netcast
Pivot table
SMALL function in Excel
Sorting data using a formula
Sorting data without changing the original order
Tips for using SMALL and LARGE functions

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152464/

More from this channel