How to use index match small large combo function in Excel
In this tutorial you’ll learn how to use index match small large combo function in Excel. We will use these in combination to find the top 20 and bottom 20 values. They will return the values and related data.
Chapters:
0:00 Intro
0:11 Prep
1:37 Lesson
12:22 Wrap up
13:50 Outro
FUNCTIONS:
**These are for structure reference only. Be sure to change to reflect where data is in your worksheet.**
SMALL:
=SMALL(Table1[[#All],[Sales]],H2)
LARGE:
=LARGE(Table1[[#All],[Sales]],D2)
INDEX SMALL:
=INDEX(Table1[[#All],[Fruit]],MATCH(SMALL(Table1[[#All],[Sales]],H2),Table1[[#All],[Sales]],0))
INDEX LARGE:
=INDEX(Table1[[#All],[Fruit]],MATCH(LARGE(Table1[[#All],[Sales]],D2),Table1[[#All],[Sales]],0))
SOFTWARE:
https://melcompton.com/recommends/adobe/
GEAR:
Lenovo ThinkPad Laptop: https://amzn.to/2NvXTGU
Dell Monitors: https://amzn.to/3r0iwte
VIVO Dual Monitor Mount Stand: https://amzn.to/3bBmJ0f
Logitech Wireless Mouse and Keyboard: https://amzn.to/2OX7V4g
Powered USB Hub: https://amzn.to/3bBmCBR
Behringer UM2 Audio Interface: https://amzn.to/3uUWPNE
Audio-Technica Headset: https://amzn.to/2Np3Qpl
WC Wicked Cushions Replacement Earpads: https://amzn.to/3uoihuh
LET’S CONNECT:
Facebook: / therealmelcompton
Twitter: / melissaecompton
LinkedIn: / melissa-compton-17701240
Instagram: / melissaacompton
NOTE: This description contains affiliate links, which means at no additional cost to you, I will receive a small commission if you make a purchase using the links. This helps support the channel and allows me to continue making videos like this. Thank you for your support!
#MelissaCompton #Excel #Functions