Smallest And Largest N Values In A Range Using SMALL And LARGE Functions - The Excel Hub
We cover how to extract the nth smallest and nth largest items of a list in Excel. In our example, we have the fictitious returns of various industries and want to identify what the top and bottom 5 returns are and which industry they correspond to. Instead of filtering, we use the SMALL and LARGE functions. We then use the VLOOKUP function to extract the industries that correspond to the n smallest and largest returns.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Smallest And Largest N Values In A Ra...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Nth Largest: (0:45)
Nth Smallest: (3:21)