How to Quickly Find 1st, 2nd, 3rd Largest or Smallest Values in Excel - LARGE & SMALL
Excel's LARGE & SMALL functions help you sift through data and find out the highest, or lowest, second highest or lowest, or the nth highest or lowest values with ease.
MAX and MIN function only allowed you to extract the highest or the lowest value, whereas LARGE and SMALL, besides doing that, go even further.
With simple and similar syntax, these functions just take a few moments to understand and are a must know in case your work involves analyzing data frequently.
🕙 You can use these timestamps in case you are looking for something specific
00:00 - Introduction
00:30 - Finding the highest value using MAX
00:49 - Finding the second largest value using LARGE
01:28 - Finding the highest value using LARGE
01:50 - Finding the lowest value using MIN
02:07 - Finding the second smallest value using SMALL
02:26 - Finding the lowest value using SMALL
✅ Subscribe to our Channel to level up your Excel skills faster
/ @analyticssuccess
⬇️ Download the file used in the video
https://www.qling.net/11174/files/66c...
💻 Courses offered by us
Learn more about our Excel Masterclass course
https://yt.qling.net/excel-masterclass
Explore all courses
https://yt.qling.net/courses
📘 Download our E-Book on Excel Shortcuts (Windows and Mac)
https://yt.qling.net/excel-shortcuts
🗂️ Access all our templates and E-Books
https://yt.qling.net/templates-and-eb...
🤝 Connect with us
LinkedIn: / qling1
Facebook: / learnatqling
Instagram: / learnwithqling
Pinterest: / learnatqling
Get in touch: https://quiz.qling.net/get-in-touch/
#analyticssuccess, ExcelTipsAndTricks, LargeSmallFunctions, ExcelFormulasMastered, ExcelPowerUser, #MicrosoftExcelTutorials, #ExcelShortcuts, #ExcelFormulasAndFunctions