Скачать с ютуб SMALL & LARGE functions - Dynamic Ranking | Google Sheets Formulas 37 в хорошем качестве

SMALL & LARGE functions - Dynamic Ranking | Google Sheets Formulas 37

In this lesson, We are going to explore: 0:00 Getting started. 0:39 The SMALL and LARGE functions (Dynamic Ranking). All explanations are simple and to the point. Feel free to make your copy of this spreadsheet: https://docs.google.com/spreadsheets/... #GoogleForEducation #GoogleWorkspace #GoogleSheets If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded Useful Link: Ben Collins (Google Developer Expert & Data Analytics Instructor) https://www.benlcollins.com/ Google Sheets training: https://support.google.com/a/users/an... The whole playlist link:    • The most useful formulas - Google She...   Follow us on Pinterest: https://www.pinterest.it/GoogleWorksp... Sound from Zapsplat.com Apple logo https://iconscout.com/contributors/pi... Windows logo https://pixabay.com/it/users/ Welcome back, Educators. Our mission is to rank the scores of our students dynamically. To facilitate typing the formula we’ve named these ranges. We’ve created a drop-down menus consist of the numbers one to ten. Let’s start building the formula step by step. Type =LARGE( Select the data. The rank is the number in the F1. Press Enter. The formula returns one value. To expand it, we use the SEQUENCE function. Surround the SEQUENCE with curly brackets. Surround all with the ArrayFormula function. Press Enter. The formula returns several values equivalent to the number in the F1. To return the names of the students and whose scores, we use the VLOOKUP. Type = VLOOKUP( The search key is the LARGE formula. We reverse the range. The index is {2,1} to return the name of the student first, then the score. Type 0 to search for the exact selected value. Press Enter. Copy the whole formula. Then paste it under the worst. Change the LARGE too SMALL. Change the F1 to I1. Press Enter. We’ve done the mission. That’s it, have fun. Thanks for watching. If you like the video, please give us a thumbs up. And subscribe to our channel.