The Large and Small Function
Most Excel users know MIN and MAX.
But what happens when you need the 2nd highest sale, the 5th largest invoice, or the 10th lowest cost?
That's where LARGE and SMALL come in.
In this video, LARGE and SMALL explain exactly how they work, when to use them, and why they're essential for dashboards, management reports and business analysis.
Using practical business examples, you'll learn how to rank data, build Top 10 reports, identify the highest and lowest performers.
In this video you'll learn:
• The difference between LARGE/SMALL and MAX/MIN
• How the LARGE and SMALL functions work
• Understanding the K (ranking) argument
• Finding the 2nd, 3rd, 5th or 10th highest and lowest values
• Building Top 10 and Bottom 10 reports
Whether you work in finance, sales, HR, purchasing, operations or management, these functions will help you analyse data more effectively and build reports that answer real business questions.
This video is part of our Excel Functions Explain Themselves series, where Excel functions explain what they do, how they work, and where they're used in the real world through practical business examples.
If you enjoyed this lesson, please Like, Subscribe and turn on notifications. New videos are published regularly covering Excel functions, Pivot Tables, dashboards, AI with Excel and practical spreadsheet skills you can use immediately.
#Excel #LargeFunction #SmallFunction #MicrosoftExcel #ExcelFunctions #ExcelTips #ExcelTutorial #DataAnalysis #Dashboard #ConditionalFormatting #LearnExcel #ExcelTraining
On this page of the site you can watch the video online The Large and Small Function with a duration of hours minute second in good quality, which was uploaded by the user OnlineExcelTraining 10 July 2026, share the link with friends and acquaintances, this video has already been watched 3 times on youtube and it was liked by 1 viewers. Enjoy your viewing!
