Рет қаралды 112
Find the SMALLEST Number in SECONDS with Excel's SMALL Function!
👉 Learn Excel the right way with our highly-rated course: bit.ly/4gHGZy0
❤️ FREEBIES FOR YOU!!
►► Grab a copy of our free "Top 29 Excel Shortcuts" PDF cheatsheet: bit.ly/3YkqaSt
►► Download the Excel file used in this video: bit.ly/4dpq3d1
►► Join our newsletter and get free Excel tips, tricks and exclusive course discounts: bit.ly/3UaUkFb
In this video, you’re going to learn how to use Excel’s SMALL function to find the smallest or lowest value from a set of numbers. We’ll walk you through: how the SMALL function works to locate the smallest values; how to find not only the smallest number but also the second smallest or any other ranked value in your data set; and how to find the smallest number that’s not a zero.
⌚ TIMESTAMPS
00:00 Find the SMALLEST Number in SECONDS with Excel's SMALL Function!
00:42 Finding the smallest number
01:46 Finding the second smallest number
02:30 Finding the smallest number with a blank cell
03:12 Finding the smallest number with a zero
03:53 Finding the smallest number ignoring zeros
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚖ DISCLAIMER
Information provided in our videos does not constitute financial, taxation, legal, business or other professional advice. If you make a purchase through an affiliate link provided here we may receive a commssion. We do not accept any responsibility or liability for purchases made through third-party vendors, websites, or services. It is your reponsibility to review and understand the terms, conditions, and policies of third parties before making any purchases.